Filter Pane

[UserID2626]

Hi,

Need to create a Simple filter pane as range value like below image without creating a range value manually

And selection of filter will reflect in table

if i select 0-50, the value falls under 0-50 should be displayed

thanks,

[pradosh_thakur · Accepted solution]

if value is your field then

pick(match(-1,value < 50, value >= 50 and value < 100,value >= 100 and value < 150,value >= 150 and value < 200, value >=200),'0-50','50-100','100-150','150-200','>200') as Range

[UserID2626]

Could you please explain why you given -1 in match() function

Thanks 🙂

[pradosh_thakur]

True is represented -1 and flase as 0 in Qlik. So when the condition is true it will be -1 else 0. So when the value matches the criteria the condition becomes -1 and matches.

[vikasmahajan]

if(year(Month_Year)>=year(addyears(max(total {1}[Month Year Num]),-1)) and Month_Year<= $(vDisplayMaxMonthYear) ,Month_Year)