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: 
ValeriaBonini
Partner - Creator
Partner - Creator

Hide dimension total in pivot table

Hi, I have a pivot like this, where I have some measures and two columns that are in text format

I would like to hide the total from the dimensions columns

how can I do? 

ValeriaBonini_0-1696234516107.png

 

Labels (5)
1 Solution

Accepted Solutions
sbaro_bd
Creator III
Creator III

Hi @ValeriaBonini ,

It's not like Qlikview, you can't hide total for a specific calculation. In Qlik Sense, the show/hide option is for all measures.

However, you can use a workaround : an expression like this  : IF(Dimensionality()=0,'',<your_measure>). The total will be blank. 

Regards.

View solution in original post

2 Replies
sbaro_bd
Creator III
Creator III

Hi @ValeriaBonini ,

It's not like Qlikview, you can't hide total for a specific calculation. In Qlik Sense, the show/hide option is for all measures.

However, you can use a workaround : an expression like this  : IF(Dimensionality()=0,'',<your_measure>). The total will be blank. 

Regards.

ValeriaBonini
Partner - Creator
Partner - Creator
Author

Thank you so much