Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Thevarupan1212
Contributor
Contributor

Qlik Sense Ranges

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

 

 

1 Solution

Accepted Solutions
Vegar
MVP
MVP

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.

View solution in original post

2 Replies
Vegar
MVP
MVP

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.

Thevarupan1212
Contributor
Contributor
Author

Hi Vegar , 

 

Thanks ! it helps ! 🙂