Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Creator III
Creator III

Filtering on a range

Question about filters:

Can you create a filter that will filter on the data based upon a measurement falling in a range ?

That is - say you want to have a filter for the value amount - the filter would have the following to select from :

 Under 2

2+ - 3

3+ to 5

5+ to 10

Over 10

 

and if the user selects 2+ - 3 , the sheet will filter and only show results were the Amount measure is between 2 and 3.

 

thoughts ? Jerry

 

 

Labels (1)
2 Replies
vaisgaard
Contributor III
Contributor III

Hi Jerry,

Normally I would create the measure/calculation in the loadscript. Then it becomes a dimension you can filter on.

If your calculation is a dimension, then you can use ranges in the filter on tables. If you want to have a filterpane instead, then I would create that in the loadscript as well. You can do that by using if() statements.

I hope that helps.

Best regards

Michael

Best regards
Michael Vaisgaard
JordyWegman
Partner - Master
Partner - Master

Hi Jerry,

See this example:

 

Table:
Load * Inline [
Value
1
2
3
4
5
6
7
8
9
10
11
12
];

FinalTable:
Load
  Value,
  IF(Value >= 0 and Value <= 3, '0-3',
    IF(Value >= 4 and Value <= 10, '4-10',
       IF(Value >= 11, '11+','<0'))) as Category
Resident Table;

Drop table Table;

 

Jordy

Climber

Work smarter, not harder