Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Range Filter Selections

I'm attempting to create a filter with option selectors for months 6 months out from a value, in my case SERVICE_DATE. I've read that I could use =pick(math( for this, and my formula looks like:

 

=pick(match(-1,SERVICE_DATE <= addmonths(SERVICE_DATE,6) and SERVICE_DATE <= addmonths(SERVICE_DATE,5) and SERVICE_DATE <= addmonths(SERVICE_DATE,4) and SERVICE_DATE <= addmonths(SERVICE_DATE,3) and SERVICE_DATE <= addmonths(SERVICE_DATE,2) and SERVICE_DATE <= addmonths(SERVICE_DATE,1)),'6 Months','5 Months','4 Months','3 Months','2 Months','1 Month')

 

Not having much luck. It will display for me '6 Months' as an option, but no others.

0 Replies