QlikView App: Dynamic Date Dimension - With Hours

[stevedark]

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/

[rustyfishbones]

This is great stuff Steve thanks for sharing!

[marcus_malinow]

Love it, will look forward to trying it out in some of my own applications. Thanks Steve!

[#4]

A very smart programmed selection method and very intuitive for the user. The user is getting what he wants without clicking on special buttons or icons.

Selecting one month and you are getting the days of the month, Selection multiple months and you are getting the months.

Selecting one day you are getting the hours. Selection multiple days you are getting the days.

Etc

[stevedark]

Thanks Nico, glad you like the app.

[ogster1974]

Hi Steve

Loving the work.

I look forward to looking at this in more detail and seeing how I can apply it into my own reports.

[stevedark]

Hi Andy,

Many thanks.  There are links to other bits and bobs I have uploaded here:

http://www.quickintelligence.co.uk/qlikview-examples/

Steve

[#8]

Hi Steve

i checked ur application.. it really shows Good.. but how u  created this application and

Dynamic Date Dimension - With Hours

can u help me

[stevedark]

I've not created a blog post for this app, so there are no instructions as such.  It should be possible to reverse engineer it by looking at the code.

How far have you got and what error are you presently seeing?

Steve

[ecolomer]

Thank's for sharing

Good work

Saludos,

Enrique Colomer

[manojkulkarni]

thanks for sharing document. Good one