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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table subtotal coloumn removal

Hi Guys

How should I remove subtotals row without affecting other calculations .

Please let me help for the same expecting quick reply from anybody .

Regards

Go....COOL

12 Replies
Not applicable
Author

How about this:

On [Support Month] dimension, TextColor expression set to

=



if( [Support Month]='*', rgb(255,255,255))

Set the same for the expression TextColor.

It sort of 'hide' it. I saw you using this as one of your attempt. So I don't think you mind this. Hope this helps.

Not applicable
Author

Hi Friend it wont work in my case I had tried thi one

Not applicable
Author

what expression did you use?

when you said it's not working, does that mean the textcolor doesn't change to white?