topic Re: Qlik Sense - pivot table show dimension total in App Development

Qlik Sense - pivot table show dimension total

agigliotti — Fri, 21 Oct 2016 08:52:59 GMT

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.

Andrea

Re: Qlik Sense - pivot table show dimension total

Gysbert_Wassenaar — Fri, 21 Oct 2016 09:22:09 GMT

Please let me know.

What do you want to know?

Re: Qlik Sense - pivot table show dimension total

agigliotti — Fri, 21 Oct 2016 09:27:20 GMT

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

Re: Qlik Sense - pivot table show dimension total

shraddha_g — Fri, 21 Oct 2016 09:31:03 GMT

You are anyway able to see subtotals if not fully expanded

Re: Qlik Sense - pivot table show dimension total

Gysbert_Wassenaar — Fri, 21 Oct 2016 09:40:16 GMT

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

Re: Qlik Sense - pivot table show dimension total

agigliotti — Fri, 21 Oct 2016 09:42:40 GMT

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

Re: Qlik Sense - pivot table show dimension total

shraddha_g — Fri, 21 Oct 2016 09:44:14 GMT

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

Re: Qlik Sense - pivot table show dimension total

agigliotti — Fri, 21 Oct 2016 09:46:42 GMT

Please take a look below:

show totals is only available on first dimension.

is now clear what I means ?

Re: Qlik Sense - pivot table show dimension total

Gysbert_Wassenaar — Fri, 21 Oct 2016 09:47:59 GMT

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.

Re: Qlik Sense - pivot table show dimension total

shraddha_g — Fri, 21 Oct 2016 09:51:49 GMT

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.

Re: Qlik Sense - pivot table show dimension total

agigliotti — Fri, 21 Oct 2016 10:04:40 GMT

Ok I saw.

Re: Qlik Sense - pivot table show dimension total

shraddha_g — Fri, 21 Oct 2016 10:12:54 GMT

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.

Re: Qlik Sense - pivot table show dimension total

agigliotti — Fri, 21 Oct 2016 10:29:31 GMT

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.

Re: Qlik Sense - pivot table show dimension total

shraddha_g — Fri, 21 Oct 2016 10:31:46 GMT

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

Re: Qlik Sense - pivot table show dimension total

agigliotti — Mon, 10 Apr 2017 13:19:10 GMT

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

Re: Qlik Sense - pivot table show dimension total

santhoshkasam09 — Mon, 07 May 2018 09:07:25 GMT

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

Re: Qlik Sense - pivot table show dimension total

agigliotti — Tue, 08 May 2018 07:42:13 GMT

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