topic Re: How to hide column in Pivot table but have partial sums shown. in QlikView

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

Wed, 12 Jun 2013 16:30:51 GMT

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

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

Gysbert_Wassenaar — Wed, 12 Jun 2013 16:34:38 GMT

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))

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

Anonymous — Wed, 12 Jun 2013 19:32:50 GMT

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

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

Thu, 13 Jun 2013 08:48:05 GMT

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

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

Thu, 13 Jun 2013 08:48:52 GMT

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

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

Anonymous — Thu, 13 Jun 2013 12:04:48 GMT

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

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

Thu, 22 Jan 2015 05:48:19 GMT

Hi,

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

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

robert_mika — Thu, 22 Jan 2015 06:05:47 GMT

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)