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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
agigliotti
MVP
MVP

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
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
MVP
MVP
Author

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
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
MVP
MVP
Author

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
shraddha_g
Partner - Master III
Partner - Master III

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

agigliotti
MVP
MVP
Author

Please take a look below:

Image 1.png

show totals is only available on first dimension.

is now clear what I means ?

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
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.