topic % from total in QlikView

% from total

francisvandergr — Tue, 17 May 2011 12:59:23 GMT

I have a table, and what i want is on each row a % from the total value of the comun. At debtor 0003 i wanna see 50%. Because i have an amount of 3000 from total 6000. I attached an example.

% from total

erichshiino — Tue, 17 May 2011 13:06:57 GMT

Hi,
Add this expression:

sum(Orderamount)/

sum(total Orderamount)

'Total' means that the sum will ignore the dimension to give you the sum of all Orderamount.

This will then give you the % of total

Hope it helps,

Erich

Re: % from total

brenner_martina — Tue, 17 May 2011 18:52:23 GMT

Hi, Francis,

and you can enter one or more dimensions to define, which Total or Subtotal will be taken:

sum(Orderamount)/

sum(total <Dim1,Dim2,...> Orderamount)

Best greetings from Munich

Re: % from total

nagaiank — Tue, 17 May 2011 19:03:46 GMT

For this example, checking the "Relative" box in the expression tab will give you the percentage instead of your calculating it, as seen from the attached file.