Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using pivot table partial totals to create a graph

Hi everyone,

Is there a way to store the "show partial sum" value from a pivot table? I want to use these values to create a graph, but have been unable to find any discussions on the matter. I don't see another way to dynamically create the sum of each column in my pivot table, so please let me know if there's a way.

Thanks in advance for your help.


Barbara Cleary

Additional details on the project I'm working on if need be:

  • I created a pivot table which calculates the affect of price/volume/mix in my department's margin. Dimension is each customer.
  • I have "show partial sum" selected in order to sum the affects of price/volume/mix for all customers.
  • I'm looking to create a waterfall graph to "walk" from margin in one month to margin in the second month.
  • This would show the dollar effect of volume, price, and mix as a whole for all customers combined
0 Replies