Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
googel84
Partner - Creator III
Partner - Creator 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.

0 Replies