Quarter Date in format "Qn YYYY"

[JuvenalWilli]

Hello community,

I'm totally new to Qlik so please forgive me if my question seems redundant and basic;

Ihave this script that shows the date in "Month YYYY", i would like to modify it so that it is shown as "Qn YYYY"

=if(vData='0',
if(monthstart(MONTH_SK)>'04/01/2017' and All_ETP='1',Date(MONTH_SK, 'MMM''YY')),
if(vData='_1',
if(All_ETP_1='1' and monthstart(MONTH_SK)>'04/01/2017', Date(MONTH_SK, 'MMM''YY')),
if(All_ETP_2='1' and monthstart(MONTH_SK)>'04/01/2017', Date(MONTH_SK, 'MMM''YY'))
))

Thanks so much in Advance

[MayilVahanan · Accepted solution]

Hi 

Try like below

Dual('Q'&Ceil(Month(MONTH_SK)/3)&'-'&Year(MONTH_SK),QuarterStart(MONTH_SK))

Hope it helps

[JuvenalWilli]

That works, thanks so much!!