Calendar Hierarchy

[Anonymous]

Does anyone have a script written that would create a calendar hierarchy (version 9.x hierarchy) that they are willing to share? Looking for the hierarchy of Year-Quarter-Month-Date.

Thanks in advance.[:D]

-Brian

[prieper]

There were several threads for this - just search the forum.

Peter

[Anonymous]

I've look searching for "Treeview hierarchy" and "Treeview calendar" and "hierarchy dates" and "hierarchy calendar". Unfortuantely I can't find what I need. So I'm trying myself.

I've got it working except that my months are not sorting correctly and my dates are not formatting. Below is my Excel flie layout and I'm also uploading my test file. Any help is greatly appreciated!

Excel file sample data:

Year	Month	Date	ConcateDate
2004	Jan	1/1/2004	2004|Jan|37987
2004	Jan	1/2/2004	2004|Jan|37988
2004	Jan	1/3/2004	2004|Jan|37989
2004	Jan	1/4/2004	2004|Jan|37990
2004	Jan	1/5/2004	2004|Jan|37991
2004	Jan	1/6/2004	2004|Jan|37992

[Anonymous]

Brian,
See my Wiki post "How to create a Calendar".
To get months to sort correctly, create them drom dates:
month(date) as Month

[#5]

Hi,

do you want something like the Attached one?

Idea is, generating a Parent Child table from a Calendar an resident load it as hierarchy.

Have Fun with qlik

Alex

[#6]

Hi,

your solution is really interesting. How can I "connect" it to existing data model (I have a fiscal year calendar table that is connected to the data via SERVICE_DATE field?