Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY

Partial Sums in straight table | Custom Labels in Pivot SubTotals

vinieme12
Champion II
Champion 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
Creator II
Creator II

Very usefull, thanks for sharing!

0 Likes
beck_bakytbek
Master
Master

Thanks for sharing

0 Likes
qlikviewnovice
Specialist II
Specialist II

Nice!!

0 Likes
nzamor01
Enthusiast II
Enthusiast II

Thanks, very usefull

0 Likes
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.

0 Likes
vinieme12
Champion II
Champion II

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

0 Likes
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.

0 Likes
vinieme12
Champion II
Champion II

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

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