Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sadasiva
Contributor

How to get Totals at multiple levels in Qliksense Pivot table

Hi,

Can some one tell me how can i achieve this ?

Regards,

Sadasiva

Tags (1)
1 Solution

Accepted Solutions

Re: How to get Totals at multiple levels in Qliksense Pivot table

Do the row Total toggles appear on all rows if in Appearance | Presentation  you untick Indent Rows ?

7 Replies

Re: How to get Totals at multiple levels in Qliksense Pivot table

Select Show Totals for each Row you wish to have Totals on.

sadasiva
Contributor

Re: How to get Totals at multiple levels in Qliksense Pivot table

Hi Bill,

Thanks for the reply. I am using multile dimensions in a pivot table. We can show the show the totals for the first dimension. How to show totals for other dimensions as well?

Thanks,

Sadasiva

agigliotti
Honored Contributor II

Re: How to get Totals at multiple levels in Qliksense Pivot table

the grand total is only for the first dimension.

if you drag and drop other dimension as first you 'll lose the grand total.

Re: How to get Totals at multiple levels in Qliksense Pivot table

Do the row Total toggles appear on all rows if in Appearance | Presentation  you untick Indent Rows ?

sadasiva
Contributor

Re: How to get Totals at multiple levels in Qliksense Pivot table

Thanks a lot, this helps.

Re: How to get Totals at multiple levels in Qliksense Pivot table

I think this behaviour in Qlik Sense is a bit of a buglet, especially as if one re-ticks Indent Rows all the Row level totals remain.

Not user friendly, more user hostile.

srishsum2017
Contributor

Re: How to get Totals at multiple levels in Qliksense Pivot table

Hi Partial sum is not available in qliksense, either use fully expanded otherwise if you check show totals you get total on first row

Community Browser