topic Re: Hide & Show expression column in pivot table in QlikView

Hide & Show expression column in pivot table

abc_18 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Is it possible to hide a expression column in pivot table conditionality, but when we click on subtotal(Partial sum) that column should appear??

Re: Hide & Show expression column in pivot table

Chanty4u — Tue, 03 May 2016 07:13:06 GMT

hi,

chk dis

Hiding expression column in Pivot table

Re: Hide & Show expression column in pivot table

Chanty4u — Tue, 03 May 2016 07:13:55 GMT

chk dis tooHow to hide column in expression in pivot table

Re: Hide & Show expression column in pivot table

abc_18 — Tue, 03 May 2016 08:42:19 GMT

Hi,

Thanks for your reply.

But my requirement is like that particular expression should hide, but upon selection on subtotal column(Dimension in which partial sum condition is applied in presentation tab) then that particular expression column should appear.

Re: Hide & Show expression column in pivot table

abc_18 — Tue, 03 May 2016 09:13:08 GMT

Hi,

Issue is resolved now.

I have used GetCurrentSelections() and GetPossibleCount() function.

Expression is:

If( IsNull( GetCurrentSelections()) ,0, GetPossibleCount(Dimnsion))