Hide Column in Pivot Table

[manojkulkarni]

Hi Friends,

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

[sunny_talwar]

Nothing that QlikView has, but may be using a Macro

Pivot Column Width to Zero

[manojkulkarni]

Will this work on Access Point ?

[sunny_talwar]

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

[manojkulkarni]

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 ?

[manojkulkarni]

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

[sunny_talwar]

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

[vishsaggi]

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

[kamal_sanguri]

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.

[jonathandienst]

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.