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.