Documents for QlikView related information.
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
Very usefull, thanks for sharing!
Thanks for sharing
Thanks, very usefull
Suppose one/two Name is common in two country then how we can handle this with the above code.
that should not make any difference, because are associating the tables based on the Country and not the name
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.
Edit the script and Add Ted to Japan too reload and check it out