Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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
Creator

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
Creator

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