Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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.