Hiding/showing pivot table columns - smarter solution

googel84 — Mon, 18 Oct 2010 11:51:06 GMT

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.

topic Hiding/showing pivot table columns - smarter solution in QlikView

Hiding/showing pivot table columns - smarter solution

Solution #1

Solution #2