Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, I'm trying to work on the range in Qlik Sense.
I'm using a filter pane to display the range between values. For example, i'm gonna display value less than 15, less than 30 and less than 60. Tried the usual formula as per below. So when i click on less than 30 im getting values LESS THAN 30 BUT MORE THAN 15.
IF([Expiry Date] <15, '<=15',
IF( [Expiry Date] <= 30, '<=30',
IF([Expiry Date] <= 45, '<=45',
IF([Expiry Date] <= 60, '<=60')))) .
I need to display value where if i click on less than 30, it should display 0-30. if less than 45 then 0-45 and if less than 60 then 0-60.
Appreciate if i can get help on this 🙂
thanks
The pane is behaving as I would expect. You can't really force a data point (Expiry Date) to have more than one value in a filter pane. You should have a different approach.
Try to create a field containing your interval names that is associated with Expiry Date. This pseudo codeicode show one way of solving .
Do something like this in your script:
Load RangeMin & '-' & RangeMax as Range,
Iterno()-1 as [Expiry Date]
Inline [
RangeMin, RangeMax
0,15
0, 30
0,45 ]
While iterno()-1 <= RangeMax ;
Another approach could be to use IntervalMatch() to solve your issue.
The pane is behaving as I would expect. You can't really force a data point (Expiry Date) to have more than one value in a filter pane. You should have a different approach.
Try to create a field containing your interval names that is associated with Expiry Date. This pseudo codeicode show one way of solving .
Do something like this in your script:
Load RangeMin & '-' & RangeMax as Range,
Iterno()-1 as [Expiry Date]
Inline [
RangeMin, RangeMax
0,15
0, 30
0,45 ]
While iterno()-1 <= RangeMax ;
Another approach could be to use IntervalMatch() to solve your issue.
Hi Vegar ,
Thanks ! it helps ! 🙂