Max Functions returns the maximum numeric value of expression encountered over a number of records as defined by a group by clause. Rank defaults to 1 which corresponds to the highest value. By specifying rank as 2 the second highest value will be returned. If rank is 3 the third highest value will be returned and so on.
Master Calendar Creation in Qlikview
In my early post I explain about the Master Calendar Creation in this post I explain about how to identify the master calendar creation date and then create the master calendar script in the qlikview edit script. Because in the qlikview dates field has very important to visualize any data model or any business and it has specific reason for creation of different date fields. This date fields provide a filter or a dimension to get the Metric value in the data model for better visualize. So have a look for steps how to create the master calendar.
Ex:- Year, Month, Quarter, Week, Week Day, Day, In Year, YTD, MTD etc
First identify which is transactional date in your data model for which you want to create the master calendar ans which is based on this date.
In this step we need to find the minimum and Minimum and Maximum date in the model and then load into the table and from table we have to use Peek() function for capture into the variables for calendar creation.
Minimum Date Table Script
Master Calendar Table
Maximum Date Table Script
Min and Max Date Variables
Then create the rows based on the Min and Max dates into the Qlikview
And then generate full Master calendar based on this rows into proper date formats
Keep following and give feedback, And thanks for good feedback and suggestion.