Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
agigliotti
Not applicable

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
Not applicable

Re: Qlik Sense - pivot table show dimension total

Please let me know.

What do you want to know?


talk is cheap, supply exceeds demand
agigliotti
Not applicable

Re: Qlik Sense - pivot table show dimension total

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

shraddha_g
Not applicable

Re: Qlik Sense - pivot table show dimension total

You are anyway able to see subtotals if not fully expanded

Gysbert_Wassenaar
Not applicable

Re: Qlik Sense - pivot table show dimension total

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


talk is cheap, supply exceeds demand
agigliotti
Not applicable

Re: Qlik Sense - pivot table show dimension total

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

shraddha_g
Not applicable

Re: Qlik Sense - pivot table show dimension total

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

agigliotti
Not applicable

Re: Qlik Sense - pivot table show dimension total

Please take a look below:

Image 1.png

show totals is only available on first dimension.

is now clear what I means ?

Gysbert_Wassenaar
Not applicable

Re: Qlik Sense - pivot table show dimension total

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
Not applicable

Re: Qlik Sense - pivot table show dimension total

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.