article QlikView App: Dynamic Date Dimension - With Hours in Member Articles

QlikView App: Dynamic Date Dimension - With Hours

stevedark — Wed, 29 May 2013 21:31:38 GMT

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/

Re: QlikView App: Dynamic Date Dimension - With Hours

rustyfishbones — Fri, 11 Oct 2013 11:09:43 GMT

This is great stuff Steve thanks for sharing!

Re: QlikView App: Dynamic Date Dimension - With Hours

marcus_malinow — Fri, 11 Oct 2013 15:55:38 GMT

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

Re: QlikView App: Dynamic Date Dimension - With Hours

Mon, 17 Nov 2014 20:49:21 GMT

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

Re: QlikView App: Dynamic Date Dimension - With Hours

stevedark — Tue, 18 Nov 2014 04:54:48 GMT

Thanks Nico, glad you like the app.

Re: QlikView App: Dynamic Date Dimension - With Hours

ogster1974 — Tue, 18 Nov 2014 12:10:03 GMT

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.

Re: QlikView App: Dynamic Date Dimension - With Hours

stevedark — Tue, 18 Nov 2014 20:31:16 GMT

Hi Andy,

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

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

Steve

Re: QlikView App: Dynamic Date Dimension - With Hours

Mon, 11 May 2015 07:44:28 GMT

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

Re: QlikView App: Dynamic Date Dimension - With Hours

stevedark — Tue, 12 May 2015 21:01:37 GMT

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

Re: QlikView App: Dynamic Date Dimension - With Hours

ecolomer — Sun, 13 Dec 2015 10:02:19 GMT

Thank's for sharing

Good work

Saludos,

Enrique Colomer

Re: QlikView App: Dynamic Date Dimension - With Hours

manojkulkarni — Mon, 14 Dec 2015 06:37:33 GMT

thanks for sharing document. Good one