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.

Qlikview Date Time Functions

Qlikview date and time functions has very important roles in Qlikview development and it is widely used in the data model creation in the Qlikview development. While creating the fact tables or dimension table creation we need to check the date fields if there is no existence of proper date dimensions then we create the Master calendar for more on master calendar creation you can see this post Master Calendar in Qlikview.

Day function:-

This function returns the day value of the date field in the data model.

Syntax:-

Day([Date field of Transaction])

Example:-

Day( ‘1990-12-25’ )             this returns 25

Day(Now())           this returns the Day value of the current time stamp value.

Day(Today())        this returns the Day value of the current today date.

Script:-

DateLoadScript

More on the date topics you can learn here Click

How to create the master you can see more here Click