topic Hide subtotal on one expression in QlikView

Hide subtotal on one expression

Thu, 28 Oct 2010 16:22:47 GMT

Dear all, I have i pivot table with a expression that is a CONCAT.

I want to hide the subtotal of that concat, but i don't know how to do that.

Can someone help me?

Option total mode is disabled.

Best regards

Hide subtotal on one expression

Thu, 28 Oct 2010 17:20:29 GMT

First, figure out the Dimensionality of the subtotal. Add Dimensionsality() as an expression. The highest level subtotal is 0 and it goes up from there. If you have a few dimensions, your data would probably be Dimensionality() 3 or something. Once you know the dimensionality of the subtotal, then do something like:

If(Dimensionality() > 2, Expression, ' ')

That will evaluate on your data and any subtotals after the first three dimensions (I believe). Modify that number until you get the results you want. I did a space in the false section of the If, because I don't want the null character in my chart, but instead a blank.

Hide subtotal on one expression

boorgura — Thu, 28 Oct 2010 19:52:19 GMT

One work-around (not the ideal way) is to custom format that cell to have the background color and font color as the same.

I know that this is not the correct way to do - but is a quick thing, till you find the right way.