How to create hierarchy calendar from master calendar

[bvssudhakar]

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

[bvssudhakar]

trdandamudi‌

Please help me to achieve this

[bvssudhakar]

vishsaggi‌

Please help me to achieve this

[vishsaggi]

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

[bvssudhakar]

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]

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]

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 · Accepted solution]

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.

[bvssudhakar]

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]

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