Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Please help me to achieve this
Please help me to achieve this
What you mean by hierarchy calendar, can you elaborate your expected output. Can you share some sample data to look into as well.
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
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
];
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
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.
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
You are welcome and good to know that it is working the way you want it.