Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide subtotal on one expression

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

2 Replies
Not applicable
Author

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.

boorgura
Specialist
Specialist

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.