Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Not applicable

Re: Filter by Ranges

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

reddys310
Not applicable

Re: Filter by Ranges

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
Not applicable

Re: Filter by Ranges

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