Qlik Community

Qlik Sense Documents & Videos

Documents & videos about Qlik Sense.

Date Manipulation in Qlik Sense

Creator
Creator

Date Manipulation in Qlik Sense

Date processing can often be hard to follow and leads to frustration. The perceived complexity is often driven from difficult to understand combinations of date functions in the autocalendar or MasterCalendar generation and no consistency of approach (every developer has their own variety of Calendar).

This app explains the calendar flags and fields through visualisation- what better way!? It uses the standard autocalendar and adds fiscal elements to it, as well as showing how the same can be generated using the MasterCalendar dimension approach.

Make selections in any of the fields to see what periods are highlighted. With a few clicks you should understand exactly how each field can be used to drive your time series analysis.


Video Link : 5575

Attachments
Comments
Specialist
Specialist

Thanks for sharing! I struggled when first dealt with the autocalendar.. I wish I'd had this. Cheers. Luis

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2017-10-10 03:46 AM
Updated by: