Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Partial Sums in straight table | Custom Labels in Pivot SubTotals

cancel
Showing results for 
Search instead for 
Did you mean: 
vinieme12
Champion III
Champion III

Partial Sums in straight table | Custom Labels in Pivot SubTotals

Last Update:

Oct 18, 2022 6:43:55 AM

Updated By:

Sonja_Bauernfeind

Created date:

Apr 4, 2017 6:17:49 AM

Attachments

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

 

Labels (1)
Comments
fheidenstecker
Creator II
Creator II

Very usefull, thanks for sharing!

beck_bakytbek
Master
Master

Thanks for sharing

Anonymous
Not applicable

Nice!!

nzamor01
Enthusiast II
Enthusiast II

Thanks, very usefull

nisha_rai
Creator II
Creator II

Hi Vineeth,

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

vinieme12
Champion III
Champion III

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

nisha_rai
Creator II
Creator 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
Champion III
Champion III

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

Version history
Last update:
‎2022-10-18 06:43 AM
Updated by: