Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to find out if a month is in between a unfinished quarter

Hi,

How can I find out if a month is in between a unfinished quarter or not in the front end.

Say for example I have Months:

Jan 2015

Feb 2015

Mar 2015

Apr 2015

May 2015

Jun 2015

Jul 2015

Aug 2015

Sep 2015

Oct 2015

Nov 2015

Dec 2015

Jan 2016

Feb 2016

Mar 2016

I have to write a different expression for Jan 2016, Feb 2016 and Mar 2016 since those months are still in between a unfinished quarter.

Whereas for the other months, the quarter has already finished.

Say for example when we are in the month of Apr 2016, I'll have one expression for all the months and a different one for Apr 2016 since it's still in between a unfinished quarter.

Hope I made myself clear.

Thanks for all the help.

Regards,

Roy

1 Solution

Accepted Solutions
sunny_talwar

Something like this?

=InQuarterToDate(Months, Today(), 0)


Capture.PNG

View solution in original post

1 Reply
sunny_talwar

Something like this?

=InQuarterToDate(Months, Today(), 0)


Capture.PNG