Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get Totals at multiple levels in Qliksense Pivot table

Hi,

Can some one tell me how can i achieve this ?

Regards,

Sadasiva

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

8 Replies
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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
Partner - Champion
Partner - Champion

the grand total is only for the first dimension.

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Thanks a lot, this helps.

Anonymous
Not applicable
Author

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
Creator
Creator

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

Sumit Kumar Srivastava
RogerioCunha
Contributor
Contributor

Unticking Indent Rows  allows me to set Show Totals for all the dimensions, but the sums aren't showing.