Filter by Ranges

[#1]

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

[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]

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')