Max Functions

Max Functions

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.

Example1:

Max Functions Grouping

Example2:

Max Functions Grouping

This Post Is Tagged

Master Calendar Creation in Qlikview

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

Step1:-

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.

Step2:-

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 Creation Min Table

Master Calendar Table

Maximum Date Table Script

Master Calendar Creation MaxTable

Min and Max Date Variables

Master Calendar Creation Variables Min Max

Step3:-

Then create the rows based on the Min and Max dates into the Qlikview

Master Calendar Creation in Qlikview Temp calendar
Step4:-

And then generate full Master calendar based on this rows into proper date formats

Master Calendar Creation in Qlikview Script

Keep following and give feedback, And thanks for good feedback and suggestion.