Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter by Ranges

Hi All,


I'd like to create a filter pane so I can break up my data by population size (peak tourism + resident population). I have tried using a pick(match) function to set the ranges but my formula isn't working and I'm a bit stuck. Any help would be appreciated.

pick(

(match(([Peak Tourist Pop]+[residentAndCommunalPop2016]),>'0'and<='100',>'100'and<='1000',>'1000'and<='10000'))

'0-100',

'100-1000',

'1000-10000')

Thank you

3 Replies
sunny_talwar

Difficult to see what you are trying to do just looking at this expression? is this a calculated dimension? What is the expression? I think it would be much easier if you can provide a sample to look at

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

reddy-s
Master II
Master II

Hi Christopher,

Are you trying to make buckets/Bins here: if so try using the class() function.

As sunny mentioned, your post is not clear enough to suggest something.

Thanks,

Sangram.

Gysbert_Wassenaar

Perhaps like this:

pick(Ceil(Log10(Rangesum([Peak Tourist Pop],residentAndCommunalPop2016])),

     '0-100',

     '0-100',

     '100-1000',

     '1000-10000')


talk is cheap, supply exceeds demand