topic % of Total Calculation in QlikView

% of Total Calculation

Tue, 13 Nov 2012 16:58:11 GMT

Hi all,

I am still relatively new to QV so bear with me! Set up a pivot tables based mostly on Product and month. Product is the row and month total sales is each column (has to be set up this way - for now).

Line 1:

PRODUCT JAN FEB MAR... YTD

Product A $10 $20 $17 etc through December and YTD

After the YTD column there should be a % of Total column. I would like this to do Product A / Total Revenue on Line 1 (Product A), Product B / Total Revenue on Line 2, etc.

Shouldn't be so hard to figure out, I wouldn't think! My challenge here is telling the expresion that Line 1 should only be Product A / Total, while Line 2 should be Product B / Total. A very basic excel template is shown to protect product names.

Hope that makes sense. Thank you very much!

Re: % of Total Calculation

Gysbert_Wassenaar — Tue, 13 Nov 2012 17:34:40 GMT

If you add an expression in the pivot table with month pivoted to columns then it will be shown as a column for every value of month. It is possible to add a calculated dimension: num(aggr(sum(Revenue),Product)/sum(total Revenue),'##.# %') to show directly after the product column.

Re: % of Total Calculation

Tue, 13 Nov 2012 18:34:54 GMT

Thanks for the tip! I used =sum(Revenue)/sum (total Revenue). Your answer worked as well.