Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
JuvenalWilli
Contributor
Contributor

Quarter Date in format "Qn YYYY"

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

 

 

1 Solution

Accepted Solutions
MayilVahanan

Hi 

Try like below

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

Hope it helps

Thanks & Regards,
Mayil Vahanan R

View solution in original post

2 Replies
MayilVahanan

Hi 

Try like below

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

Hope it helps

Thanks & Regards,
Mayil Vahanan R
JuvenalWilli
Contributor
Contributor
Author

That works, thanks so much!!