Filter by column using checkbox

[#1]

Hi there,

I wish to filter by column using checkbox.

E.g. when i check col 1, col 2 will be hidden.

How do i achieve this in QlikView?

Thanks,

Steve

[#2]

Hi,

You can create a button with actions on it, for setting variables. Put condition on list boxes based on your variables.

so when you click on the button, the other list box will hide.

Hope this helps

Regards,

Amay

[Gysbert_Wassenaar · Accepted solution]

In Qlikview 11 you can check the Conditional checkbox for dimensions and expressions and add an expression that returns 1 or 0 to show or hide the dimension/expression.

The What's New in Qlikview 11 document has an example of this on the Reports tab. Users can select which Dimensions and Measures to show in the table. A listbox is used to make the selection. If you want only one measure at a time shown you could enable the Always One Selected Value propertie of the listbox.