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.
p.s. I'm using Qlikview 11.2
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))
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), 0end sub
I tried that but I was "squeezing" also the totals column.
I had implemented that but I want to hide the columns.
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.
How to hide the row ? PFB the chart and i want to hide the JAN month row.
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)
Retrieving data ...