Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try like below
Dual('Q'&Ceil(Month(MONTH_SK)/3)&'-'&Year(MONTH_SK),QuarterStart(MONTH_SK))
Hope it helps
Hi
Try like below
Dual('Q'&Ceil(Month(MONTH_SK)/3)&'-'&Year(MONTH_SK),QuarterStart(MONTH_SK))
Hope it helps
That works, thanks so much!!