topic Re: How to create hierarchy calendar from master calendar in QlikView

How to create hierarchy calendar from master calendar

bvssudhakar — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have master calendar. Now i want create it as hierarchy calendar with year, Quarter, Month

Can you guys please suggest me the solution.

This is my master calendar script:

Calendar:

Load Dual(fYear-1 &'/'& fYear, fYear) as FYear, // Dual fiscal year

Dual(Month, fMonth) as FMonth, // Dual fiscal month

Load Year + If(Month>=$(vFM), 1, 0) as fYear, // Numeric fiscal year

Mod(Month-$(vFM), 12)+1 as fMonth, // Numeric fiscal month

Load

Date(DateNum, 'MM/DD/YYYY') as LinkDate,

Day(DateNum) as Day,

Month(DateNum) as Month,

Week(DateNum) as Week,

WeekDay(DateNum)as WeekDay,

'Q' & Ceil(Month(DateNum)/3) as Quarter,

Year(DateNum) as Year;

Load

$(vMinDate) + IterNo() - 1 as DateNum

AutoGenerate 1

While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);

Please help me to achieve this

Thank you in advance

Re: How to create hierarchy calendar from master calendar

bvssudhakar — Tue, 18 Sep 2018 13:37:56 GMT

trdandamudi‌

Please help me to achieve this

Re: How to create hierarchy calendar from master calendar

bvssudhakar — Tue, 18 Sep 2018 14:04:21 GMT

vishsaggi‌

Please help me to achieve this

Re: How to create hierarchy calendar from master calendar

vishsaggi — Tue, 18 Sep 2018 14:06:49 GMT

What you mean by hierarchy calendar, can you elaborate your expected output. Can you share some sample data to look into as well.

Re: How to create hierarchy calendar from master calendar

bvssudhakar — Tue, 18 Sep 2018 14:13:44 GMT

I have multiple date columns for them i have created one master calendar. But user wants only one list box. i.e hierarchy calendar instead of master calendar list boxes

Year

Quarter

Month

Like this i want

Re: How to create hierarchy calendar from master calendar

trdandamudi — Tue, 18 Sep 2018 14:21:21 GMT

Is this what you are looking for:

Load *,
Year &'/' &'QTR ' &QTR &'/' &Month;
Load * Inline [
Year,QTR,Month
2018,1,Jan
2018,1,Feb
2018,1,Mar
2018,2,Apr
2018,2,May
2018,2,Jun
2018,3,Jul
2018,3,Aug
2018,3,Sep
2018,4,Oct
2018,4,Nov
2018,4,Dec
];

Re: How to create hierarchy calendar from master calendar

bvssudhakar — Tue, 18 Sep 2018 15:26:28 GMT

Hi,

Previously i tried with this list box expression. If we close all that time years will be shown as white color, but it is showing as grey color. and one more is if we click on year 2018 the selection is not applying when we elaborate with that + symbol that where our fields will be visible in white color that time only we can select other wise we can't

Please suggest some other solution

Re: How to create hierarchy calendar from master calendar

trdandamudi — Tue, 18 Sep 2018 16:14:09 GMT

Please follow below link:

Hierarchy calendar as filter box

Scroll all the way to the bottom and you will see a reply from "Srikanth" and he has a .qvw attached. I think that is what you want. Hope this helps.

Re: How to create hierarchy calendar from master calendar

bvssudhakar — Wed, 19 Sep 2018 06:13:31 GMT

Hi,

Thank you very much, It's very useful. I have implemented as per qvw, it's working for me in some thing better way

Re: How to create hierarchy calendar from master calendar

trdandamudi — Wed, 19 Sep 2018 09:52:31 GMT

‌You are welcome and good to know that it is working the way you want it.

Re: How to create hierarchy calendar from master calendar

bvssudhakar — Wed, 19 Sep 2018 09:58:54 GMT

Hi Tirumaala,

Can you please look for this

how to exclude null values in straight table