Qlik Community

QlikView Documents

Documents for QlikView related information.

Partial Sums in straight table | Custom Labels in Pivot SubTotals

vinieme12
Esteemed Contributor II

Partial Sums in straight table | Custom Labels in Pivot SubTotals

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.

Pivot_CustomLabels.JPG

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


      CollapseDimension.gif

Happy Qlik'in

Cheers

Vineeth


Vineeth Pujari


Attachments
Comments
fheidenstecker
Contributor II

Very usefull, thanks for sharing!

beck110979
Valued Contributor III

Thanks for sharing

qlikviewnovice
Valued Contributor II

Nice!!

nzamor01
Visitor

Thanks, very usefull

nisha_rai
New Contributor II

Hi Vineeth,

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

vinieme12
Esteemed Contributor II

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

nisha_rai
New Contributor II

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
Esteemed Contributor II

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

Version history
Revision #:
1 of 1
Last update:
‎04-04-2017 06:17 AM
Updated by: