QlikView App: Dynamic Date Dimension

    This example shows a chart with a Dynamic Date Dimension, that shows a different date type based on the possible values of each date type.

     

    Natively QlikView allows for Drill Groups of fields, which makes it simple to create a drill down from Years, through Months and down to Dates.  This works well, but does not allow the user to view months across two years, or even some months at the end of one year and the beginning of the next.

     

    By using a Calculated Dimension this example chart chooses which date type to show, Year, Month or Date based on the number of possible values for each of those date types.  This allows for a much more dynamic and intuitive view of values over time.

     

    Steve Dark

    http://www.quickintelligence.co.uk/