topic Re: Filter by column using checkbox in QlikView

Filter by column using checkbox

Thu, 16 May 2013 03:30:45 GMT

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

Re: Filter by column using checkbox

Thu, 16 May 2013 04:22:56 GMT

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

Re: Filter by column using checkbox

Gysbert_Wassenaar — Thu, 16 May 2013 06:04:36 GMT

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.