Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Perhaps like this:
pick(Ceil(Log10(Rangesum([Peak Tourist Pop],residentAndCommunalPop2016])),
'0-100',
'0-100',
'100-1000',
'1000-10000')