Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView App: Dynamic Date Dimension - With Hours

MVP & Luminary
MVP & Luminary

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/

Labels (1)
Attachments
Comments
rustyfishbones
Honored Contributor II

This is great stuff Steve thanks for sharing!

marcus_malinow
Valued Contributor III

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


Not applicable

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

MVP & Luminary
MVP & Luminary

Thanks Nico, glad you like the app.

0 Likes
ogster1974
Honored Contributor II

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.

MVP & Luminary
MVP & Luminary

Hi Andy,

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

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

Steve

0 Likes
Not applicable

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

0 Likes
MVP & Luminary
MVP & Luminary

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

0 Likes
ecolomer
Honored Contributor II

Thank's for sharing

Good work

Saludos,

Enrique Colomer

Partner
Partner

thanks for sharing document. Good one

Version history
Revision #:
1 of 1
Last update:
‎2013-05-29 05:31 PM
Updated by: