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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
agigliotti

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
agigliotti
Author

Ok I saw.

Other question within pivot table:

Why if the user drag and drop another row dimension as first the "Totals" disappear ?

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

Because you have applied Show totals for another Dimension.

If you have noticed, Show total option is always available for First dimension.

When you change the sequence property is not checked for the newly updated 1st dimension.

You will have to manually remove and add dimension in new sequence to show total according to new sequence.

agigliotti
Author

Ok but the end user with browser can't achieve it ? Right ?

I think the total should be showed, if the option is checked, always whatever the 1st dimension.

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

It should show. But it is not possible with current version.

agigliotti
Author

I noted it still not possible with latest 3.2 SR2 version.

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

Is this option available in the version June 2017? Thank you

agigliotti
Author

the grand total is only available for the first dimension also in April 2018 version.

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