Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikview Gurus,
I have this pivot table which sums each expression column.
However, for those column which are purely text, I don't want the pivot table sum the total for me( shows as the three red crossed columns) .
Question is how can I disable the total function for those text column?
Thank you in advance!!
hi,
Uncheck "Show Partial Sums" in the Presentation tab for the dimension/expression you don't want to see totals on.
Regards,
You couldn't directly disable the total for certain dimension-values because it's a global option. But if you used a query on dimensionality() and return there NULL() and hide NULL within the presentation tab then the total row should disappear. Something like this is meant:
if(dimensionality() = 3, null(), YourExpression)
To find the right dimensionality-number add the function directly as expression and afterwards you could remove them again.
- Marcus
addition to above chk dis link How to Remove Total & Sub Total from One Column in Pivot Table?
You can use dimensionality() function to check in your expression the level of dimensionality (i.e. if you are in a total or details line), something like
= if (dimensionality() = 2, YOUREXPRESSION)
you'll need to find the correct level of dimensionality for your details line, most easiest by just creating an expression
= dimensionality()
Hi You have to un Check the Show partial sums