topic Re: % Calculation for straight table column total in QlikView

% Calculation for straight table column total

srinivasa1 — Tue, 06 Dec 2016 06:38:02 GMT

Please guide how i can do % Calculation for straight table column total.Please find attached sample on same.

Thanks in advance for any help on same

Gysbert_Wassenaar — Tue, 06 Dec 2016 08:13:51 GMT

Use explicit aggregation functions like sum:

sum([Mfg Price])

2*sum([Mfg Price]) + 3*sum(NetSalesPrice)

And set the Total mode of the expressions to Expression Default instead of Sum of Rows.

Anonymous — Tue, 06 Dec 2016 08:37:44 GMT

See if the attached helps.

As mentioned above, straight table properties, number

- check Show in % & Choose your number format

Anonymous — Tue, 06 Dec 2016 08:42:59 GMT

Or do you need the % of the total amoun?

i.e