Qlik Community

QlikView Documents

Documents for QlikView related information.

Handling Multiple Calendars.qvw

Partner
Partner

Handling Multiple Calendars.qvw

Generic calendar generation script and front end implementation example that enables scalable handling of creating and navigating multiple date fields.

It serves the purpose of:

- enabling calendar generation against any date field with a single line of code (a sub routine call)

- easily flip between different calendars by a metadata picker.

- plotting metrics against a common time line where two or more different aspects of time underpin the timeline (e.g. orders by order month and deliveries by delivery month, both plotted against a common "month-year" time axis)

Attachments
Comments
Not applicable

Great script Jonas and thanks for sharing

0 Likes
Not applicable

Really help me a lot

0 Likes
michael_gardner
Contributor III

Another method is the use of the Common Calendar vs the Generic.

Tutorial - Using Common Date Dimensions and Shared Calendars

0 Likes
Luminary
Luminary

May I suggest you generate the calendar using the speedy method: The Fastest Dynamic Calendar Script (Ever)

0 Likes
Luminary
Luminary

Here's a 'AsOf' Calendar script which makes set analysis very simple which may also be of use and can be used in conjunction with this method.

http://community.qlik.com/docs/DOC-6593

Regards

Richard

QlikCentral.Com

0 Likes
juan_c_martinez
New Contributor III

Interesting idea specially how to plot different dates in the same chart using Aggr.


Thanks.

Juan


0 Likes
rgvavihs
Valued Contributor

HI ALL ,

Please share above example in personal edition .i can't open the file .

thanks

chitemerere
Valued Contributor

Thanks for the script.  I want to create a dimension key called "Period" by concatenating the year and month into a single number.  For example, October 2011 will be stored as 201110.  How can I do this within the calendar script you availed.

Regards.

0 Likes
Not applicable

appreciate if you can copy and paste the script here as I cannot open the qvw

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-05-01 08:05 PM
Updated by: