Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bvssudhakar
Contributor II

How to create hierarchy calendar from master calendar

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

1 Solution

Accepted Solutions
trdandamudi
Honored Contributor II

Re: How to create hierarchy calendar from master calendar

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.

View solution in original post

10 Replies
bvssudhakar
Contributor II

Re: How to create hierarchy calendar from master calendar

trdandamudi

Please help me to achieve this

bvssudhakar
Contributor II

Re: How to create hierarchy calendar from master calendar

vishsaggi

Please help me to achieve this

vishsaggi
Esteemed Contributor III

Re: How to create hierarchy calendar from master calendar

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

bvssudhakar
Contributor II

Re: How to create hierarchy calendar from master calendar

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

trdandamudi
Honored Contributor II

Re: How to create hierarchy calendar from master calendar

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
]
;

bvssudhakar
Contributor II

Re: How to create hierarchy calendar from master calendar

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

trdandamudi
Honored Contributor II

Re: How to create hierarchy calendar from master calendar

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.

View solution in original post

bvssudhakar
Contributor II

Re: How to create hierarchy calendar from master calendar

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

trdandamudi
Honored Contributor II

Re: How to create hierarchy calendar from master calendar

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