topic Re: Hide Column in Pivot Table in QlikView

Hide Column in Pivot Table

manojkulkarni — Mon, 12 Jun 2017 17:30:28 GMT

Hi Friends,

I want to hide few columns in Pivot table, do we have any option to hide ?

Re: Hide Column in Pivot Table

sunny_talwar — Mon, 12 Jun 2017 17:33:03 GMT

Nothing that QlikView has, but may be using a Macro

Pivot Column Width to Zero

Re: Hide Column in Pivot Table

manojkulkarni — Mon, 12 Jun 2017 17:56:34 GMT

Will this work on Access Point ?

Re: Hide Column in Pivot Table

sunny_talwar — Mon, 12 Jun 2017 17:59:21 GMT

Yes, this is a one time macro which can be removed after you have hidden your column.

Re: Hide Column in Pivot Table

manojkulkarni — Mon, 12 Jun 2017 18:01:55 GMT

Thanks Sunny, if you don't mind pls can you send me one sample how to make call to macro & where to use in chart ?

Re: Hide Column in Pivot Table

manojkulkarni — Mon, 12 Jun 2017 18:37:12 GMT

Thanks Sunny, It worked. I would able to do it

Re: Hide Column in Pivot Table

sunny_talwar — Mon, 12 Jun 2017 18:43:08 GMT

Don't need a sample anymore? Cool... I am glad you figured it out

Re: Hide Column in Pivot Table

vishsaggi — Mon, 12 Jun 2017 20:15:27 GMT

Can you close the thread marking one of the responses as Correct/helpful please.

Re: Hide Column in Pivot Table

kamal_sanguri — Tue, 13 Jun 2017 05:58:35 GMT

We can hide them..

Use conditional enable feature and write 1=2. The expression would be hide, Dimensions can also be hide using same way.

Re: Hide Column in Pivot Table

jonathandienst — Tue, 13 Jun 2017 06:23:41 GMT

Conditionally disabling/enabling is not the same as hiding.

A hidden (zero width) column is still calculated, can be referenced by another expression, and if a dimension, still causes lines to be generated. A disabled column is not calculated, cannot be referenced and does not participate in the dimensioning of the object.

Re: Hide Column in Pivot Table

kamal_sanguri — Tue, 13 Jun 2017 06:41:46 GMT

jontydkpi Thanks for the clarification!! I didn't realize that even if we want to hide a column, still we might want to see it's effect on chart . I totally agree to your point

Have a great day.