article Partial Sums in straight table | Custom Labels in Pivot SubTotals in Member Articles

Partial Sums in straight table | Custom Labels in Pivot SubTotals

vinieme12 — Tue, 18 Oct 2022 10:43:55 GMT

Recently I have seen some threads where people have been asking for Partial Sum's / Sub Totals in a straight table.

Immediate first thought was Why Oh Why! we have a Pivot table to do just that! But there are a couple of benefits I liked when creating the solution.

What I liked:

1) Custom Labels for Subtotal , as you can see above

2) Clicking on the Subtotal Collapses the inner dimensions, YAY! Whereas the same with a Pivot table will be a two step process that is Right Click >> Collapse All

Happy Qlik'in

Cheers

Vineeth

Vineeth Pujari

Re: Partial Sums in straight table | Custom Labels in Pivot SubTotals

fheidenstecker — Thu, 06 Apr 2017 07:57:53 GMT

Very usefull, thanks for sharing!

Re: Partial Sums in straight table | Custom Labels in Pivot SubTotals

beck_bakytbek — Thu, 13 Apr 2017 07:38:38 GMT

Thanks for sharing

Re: Partial Sums in straight table | Custom Labels in Pivot SubTotals

Anonymous — Thu, 13 Apr 2017 11:23:28 GMT

Nice!!

Re: Partial Sums in straight table | Custom Labels in Pivot SubTotals

nzamor01 — Wed, 24 May 2017 22:00:26 GMT

Thanks, very usefull

Re: Partial Sums in straight table | Custom Labels in Pivot SubTotals

nisha_rai — Wed, 07 Jun 2017 12:12:46 GMT

Hi Vineeth,

Suppose one/two Name is common in two country then how we can handle this with the above code.

Re: Partial Sums in straight table | Custom Labels in Pivot SubTotals

vinieme12 — Wed, 07 Jun 2017 12:16:18 GMT

that should not make any difference, because are associating the tables based on the Country and not the name

Re: Partial Sums in straight table | Custom Labels in Pivot SubTotals

nisha_rai — Thu, 08 Jun 2017 05:57:53 GMT

in the below screen , right now "Ted" is comming under Americas only, if "Ted " is comming under Americas and Great Britain, then how we can repeat Teb two time , one for America and one for GB.

Re: Partial Sums in straight table | Custom Labels in Pivot SubTotals

vinieme12 — Thu, 08 Jun 2017 08:27:38 GMT

Edit the script and Add Ted to Japan too reload and check it out