Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor II

% Calculation for straight table column total

Hi

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


.



Tags (1)
3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: % Calculation for straight table column total

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.


talk is cheap, supply exceeds demand
Highlighted
Valued Contributor

Re: % Calculation for straight table column total

See if the attached helps.

As mentioned above, straight table properties, number

- check Show in % & Choose your number format

Highlighted
Valued Contributor

Re: % Calculation for straight table column total

Or do you need the % of the total amoun?

i.e

PercOfTotal.PNG