Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Please close the thread by marking correct answer & give likes if you like the post.

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
Please close the thread by marking correct answer & give likes if you like the post.
JuvenalWilli
Contributor
Contributor
Author

That works, thanks so much!!