topic Hide and Show Columns in a table in QlikView

Hide and Show Columns in a table

Tue, 28 Sep 2010 11:42:05 GMT

I have 25 columns in a table but I would like to have three buttons/macros which disable some of the columns so

it would be viewable. Is it possible to wirte macro about this ? / regards mikael

Hide and Show Columns in a table

Tue, 28 Sep 2010 11:59:28 GMT

Hi,

You can hide the columns in the chart properties itself.

In presentation tab, there is an option to hide the columns based on the conditions. Just check it.

Hide and Show Columns in a table

Tue, 28 Sep 2010 14:21:03 GMT

You don't need to go down the macro route with this one. Columns can only be hidden in a straight table - not a PT.

In the object properties, go to the presentation tab and you can set a conditional show for each column.

You will need to create a data island in your script (call it SelectView) and call the values something like View1, View2 and View3 (or something more appropriate).

In the conditional show, write =getfieldselections(SelectView) = View1. Now, any columns that have this will only show if you select View1 from the selection box.

This is one of a number of solutions to this.