Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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