QlikView App: Dynamic Date Dimension - With Hours

    This example is an update to a previous Shared QlikView, http://community.qlik.com/docs/DOC-4311 , which shows a chart with a Dynamic Date Dimension based on the number of possible values of each date type. This example takes it further with a drill to data at an hourly level.

     

    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.

     

    Also included in the QlikView is an example of how thin bars in QlikView 11 allow for further visualisations.

     

    Steve Dark

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