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