Defining Quarter Based on Calendar Type

[KKumar92]

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.

[MayilVahanan · Accepted solution]

HI 

Try like below

https://community.qlik.com/t5/Qlik-Design-Blog/Fiscal-Year/ba-p/1472103

[Vegar]

For setting correct Quarter field values take a look at the QuarterName() function.

[KKumar92]

Thank You, It worked,