Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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

7 Replies

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

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


talk is cheap, supply exceeds demand
mov
Esteemed Contributor III

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

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

Not applicable

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

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

Not applicable

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

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

mov
Esteemed Contributor III

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

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

Not applicable

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

Hi,

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

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

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)

Community Browser