Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am working on a demo dashboard related to financial reports. The report consist of two different calendars, and for each calendar there are set of companies belong to. Refer the table below to get an understanding to the context;
Calendar_Type | Company | Year Start | Year End |
Fis_Cal | Company A | Apr | Mar |
Nor_Cal | Company B | Jan | Dec |
Fis_Cal | Company C | Apr | Mar |
Fis_Cal | Company D | Apr | Mar |
Fis_Cal | Company E | Apr | Mar |
Fis_Cal | Company F | Apr | Mar |
Fis_Cal | Company G | Apr | Mar |
Fis_Cal | Company H | Apr | Mar |
Fis_Cal | Company I | Apr | Mar |
Fis_Cal | Company J | Apr | Mar |
Fis_Cal | Company K | Apr | Mar |
Fis_Cal | Company L | Apr | Mar |
Nor_Cal | Company M | Jan | Dec |
Requirement : Define the Quarter as per the Calendar selected. For example : if Fis_Cal is selected Q1 - Apr-Jun or if NorCal is selected Q1 - Jan-Mar. Please advise how this could be achieved.
Thanks in Advance.
HI
Try like below
https://community.qlik.com/t5/Qlik-Design-Blog/Fiscal-Year/ba-p/1472103
HI
Try like below
https://community.qlik.com/t5/Qlik-Design-Blog/Fiscal-Year/ba-p/1472103
For setting correct Quarter field values take a look at the QuarterName() function.
Thank You, It worked,