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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
agigliotti
Partner - Champion
Partner - Champion

Qlik Sense - pivot table show dimension total

Hello,

I noted the "show total" checkbox is available only for the first dimension.

I'm using the latest version 3.1.1

Please let me know.

BR

Andrea

16 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Please let me know.

What do you want to know?


talk is cheap, supply exceeds demand
agigliotti
Partner - Champion
Partner - Champion
Author

I'd expect to be able to add totals for all dimensions as in Qlikview.

shraddha_g
Partner - Master III
Partner - Master III

You are anyway able to see subtotals if not fully expanded

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You're out of luck. Subtotals are always shown.


talk is cheap, supply exceeds demand
agigliotti
Partner - Champion
Partner - Champion
Author

yes of course but I need to have subtotal showed also with dimension values expanded.

shraddha_g
Partner - Master III
Partner - Master III

With fully expanded also I am able to see sub totals.

agigliotti
Partner - Champion
Partner - Champion
Author

Please take a look below:

Image 1.png

show totals is only available on first dimension.

is now clear what I means ?

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

No. I have no idea what you want. What I do know is that you can only disable the overall totals with the Show totals option. Subtotals are always shown if you use the Indent rows option.


talk is cheap, supply exceeds demand
shraddha_g
Partner - Master III
Partner - Master III

Have a look at this.

checking and unchecking Show total option will only hide Overall Total Row (Labelled as Total). Otherwise you can see Subtotals.