Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

googel84
Contributor III

Hiding/showing pivot table columns - smarter solution

Hi everyone, I think this is a quite common issue, but I'd like to know if there is a smarter solution then the ones we thought about.

We know that it is not possible to hide or show a pivot table column simply setting something on its properties (ticking off flags, etc ... ); so we developed two different solution.

Solution #1

Using a macro to set columns width and making it to run after reload.

Solution #2

Replacing each expression with a variable containing its formula and "calling" these variables when defining a new expression. This leads to independence of indicators that can now be enabled/disabled freely.

Is there a smarter solution?

Thanks.

Tags (2)
Community Browser