topic Calendar Hierarchy in QlikView

Calendar Hierarchy

Anonymous — Fri, 13 Nov 2009 03:33:11 GMT

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

Calendar Hierarchy

prieper — Fri, 13 Nov 2009 04:44:15 GMT

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

Peter

Calendar Hierarchy

Anonymous — Fri, 13 Nov 2009 21:52:54 GMT

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

Calendar Hierarchy

Anonymous — Sat, 14 Nov 2009 04:18:12 GMT

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

AW:Calendar Hierarchy

Wed, 18 Nov 2009 22:53:33 GMT

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

Re: Calendar Hierarchy

Thu, 21 Nov 2013 13:26:05 GMT

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?