topic Re: how to hide columns in pivot table in QlikView

how to hide columns in pivot table

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

Hi,

I am new to qlikview. Can u anyone can help me in this.

Upon selection last 5 columns need to hide....

Re: how to hide columns in pivot table

Anil_Babu_Samineni — Sat, 28 Jan 2017 15:06:22 GMT

You may describe more to understand the logic?

Re: how to hide columns in pivot table

rubenmarin — Sat, 28 Jan 2017 16:36:49 GMT

Hi prathap, you'll need to give more info about what selection should hide the columns to get a specific solution.

As a general solution: In the expressions tab of the chart, check the 'conditional expressions' chekbox, set an expresion that return false (or zero) when you want hide to columns and true (or any number<>0) when you want to show the columns.

Hope this helps!

Re: how to hide columns in pivot table

vinieme12 — Sat, 28 Jan 2017 17:02:11 GMT

Please post a sample app so people here can help you better

Re: how to hide columns in pivot table

prathapg1959 — Mon, 30 Jan 2017 04:24:11 GMT

Hi Ruban,

Thanks its working fine..

Thanks to all who responded to my question...

Re: how to hide columns in pivot table

rahulpawarb — Mon, 30 Jan 2017 05:12:02 GMT

Hello Prathap,

I agree with Ruben! you can also refer the below link:

Re: Pivot table Hide measure column based on dimension value?

Regards!

Rahul

Re: how to hide columns in pivot table

oknotsen — Mon, 30 Jan 2017 09:33:09 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .

Re: how to hide columns in pivot table

surendraj — Mon, 30 Jan 2017 09:43:12 GMT

In pivot table--expressions-->Conditional...

Presentation-->