How to hide column in Pivot table but have partial sums shown.

[#1]

Hi,

I have 3 Dimensions in my pivot table and 2 expressions.

I just want one of the expressions to be shown exept in partital sums, then I want to see the totals of both expressions.

regards, Kári

p.s. I'm using Qlikview 11.2

[Gysbert_Wassenaar]

You can't hide and show a column at the same time. It is possible to only show the partial sums and leave the other cells empty. You can use the dimensionality function for that. Something like: if(dimensionality()<3, sum(Value))

[Anonymous]

It is possible by reducing the columwidth to 0.  Not possible manually, but works with a simple macro:

sub Squeeze
call HideColumn("CH01", 2)
end sub
'
private sub HideColumn(ch, n)
set ch = ActiveDocument.GetSheetObject(ch)
ch.SetPixWidth (n-1), 0
end sub

Regards,

Michael

[#4]

I tried that but I was "squeezing" also the totals column.

[#5]

I had implemented that but I want to hide the columns.

[Anonymous]

Squeeze to 0 is hiding, isn't it?  As for the hiding the right column - it is defiened by the number here, in my example it is 2:

call HideColumn("CH01", 2)

Change to whaterver you need and try again.

Regards,

Michael

[#7]

Hi,

How to hide the row ?  PFB the chart and i want  to hide the JAN month row.

[robert_mika]

Row or column?

This is Excel extract is it not?

(BTW It would be good if you start your own topic - that may attract more people to respond)