Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
There were several threads for this - just search the forum.
Peter
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 |
Brian,
See my Wiki post "How to create a Calendar".
To get months to sort correctly, create them drom dates:
month(date) as Month
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
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?