Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW

Handling Multiple Calendars.qvw

JonasValleskog
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
Creator III
Creator III

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

Tutorial - Using Common Date Dimensions and Shared Calendars

0 Likes
tseebach
Luminary Alumni
Luminary Alumni

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

0 Likes
richard_pearce6
Luminary Alumni
Luminary Alumni

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
Contributor III
Contributor III

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


Thanks.

Juan


0 Likes
rgvavihs
Specialist
Specialist

HI ALL ,

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

thanks

chitemerere
Specialist
Specialist

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
Last update:
‎2014-05-01 08:05 PM
Updated by: