Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
gznster
Contributor
Contributor

fix date months range selection

What I want 
gznster_0-1644998008318.png

What I created with the below query(i want to select the date ranges uniquely )

gznster_0-1644998775663.png

 



I'm trying to create something like this where can I click on the Tenure months and it'll query these ranges. I tried doing something like nested if else , but I'm kind of lost over here. 

 


If([TERMINATION_COMPLETION_DATE] - [TERMINATION_APPLICATION_DATE] >=0 AND [TERMINATION_COMPLETION_DATE] - [TERMINATION_APPLICATION_DATE] <=11, Dual('0-11',2),
If([TERMINATION_COMPLETION_DATE] - [TERMINATION_APPLICATION_DATE] >=12 AND [TERMINATION_COMPLETION_DATE] - [TERMINATION_APPLICATION_DATE] <=23, Dual('12-23', 2),
If([TERMINATION_COMPLETION_DATE] - [TERMINATION_APPLICATION_DATE] >=24 AND [TERMINATION_COMPLETION_DATE] - [TERMINATION_APPLICATION_DATE] <=35, Dual('24-35', 2), )))

If([TERMINATION_COMPLETION_DATE] - [TERMINATION_APPLICATION_DATE] >=0 AND [TERMINATION_COMPLETION_DATE] - [TERMINATION_APPLICATION_DATE] <=11, Dual('0-11',2),) OR
If([TERMINATION_COMPLETION_DATE] - [TERMINATION_APPLICATION_DATE] >=12 AND [TERMINATION_COMPLETION_DATE] - [TERMINATION_APPLICATION_DATE] <=23, Dual('12-23', 2),) OR
If([TERMINATION_COMPLETION_DATE] - [TERMINATION_APPLICATION_DATE] >=24 AND [TERMINATION_COMPLETION_DATE] - [TERMINATION_APPLICATION_DATE] <=35, Dual('24-35', 2), )

0 Replies