Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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))


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

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
Author

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

Not applicable
Author

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

Anonymous
Not applicable
Author

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
Author

Hi,

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

robert_mika
Master III
Master III

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)