Partial Sums in straight table | Custom Labels in Pivot SubTotals

[vinieme12]

Hi

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

[fheidenstecker]

Very usefull, thanks for sharing!

[beck_bakytbek]

Thanks for sharing

[Anonymous]

Nice!!

[nzamor01]

Thanks, very usefull

[nisha_rai]

Hi Vineeth,

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

[vinieme12]

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

[nisha_rai]

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.

[vinieme12]

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