topic How to Hide first Calculated dimension with pivot table in QlikView

How to Hide first Calculated dimension with pivot table

Anonymous — Wed, 24 Jan 2018 07:18:36 GMT

Hi Experts,

how to Hide first Dimension in Pivot table

kaushiknsolanki — Wed, 24 Jan 2018 07:29:38 GMT

Hi,

There is no default way to hide the dimension in Pivot table.

You can tell us what you want to achieve doing that.

Regards,

Kaushik Solanki

Clever_Anjos — Wed, 24 Jan 2018 09:29:21 GMT

Would you mind sharing a screenshot or a mockup of what you´re trying to do?

Anonymous — Wed, 24 Jan 2018 09:49:56 GMT

Hi Kaushik,

I tried to write in Macro that is working fine .

I am looking for UI and script level....below my macro code

sub Squeeze

call HideColumn("CH01", 1)

end sub

private sub HideColumn(ch, n)

set ch = ActiveDocument.GetSheetObject(ch)

ch.SetPixWidth (n-1), 0

end sub