Qlik Button Help

[Bharathi09]

Hi All,


I have 4 below conditions for each Filter panes

=If(CNLevelOrder < 14, CNLevelSelect)

=IF(CNLevelOrder<28 and CNLevelOrder>13, CNLevelSelect)

=IF(CNLevelOrder<40 AND CNLevelOrder>27, CNLevelSelect)

=IF(CNLevelOrder>39,CNLevelSelect)

The filterpanes will have CNSelect column values

Now, I have to create 2 buttons for above filters , one button as Select All CN Level and other button as Deselect All CN Level

if i click Select All CN Level button it should select all the values from 4 filter panes

How can I do that?
Please help

[jchx]

Is there any reason why you would use 4 filter panes? Kind of out of the norm. I'd suggest that you create a new dimension using an expression like this and use it in a single filter pane, instead of having 4 filter panes:

=If(CNLevelOrder< 14, 'Under 14',if((CNLevelOrder<28 and CNLevelOrder>13), 'Between 14 and 27 (Inclusive)'))

[Bharathi09]

Hi I need to create 4 filter panes on Same column with 4 different conditions, it's the requirement
and when I select select all then it has to select all records from 4 filterpanes