Discussion Board for collaboration related to QlikView App Development.
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
Use explicit aggregation functions like sum:
2*sum([Mfg Price]) + 3*sum(NetSalesPrice)
And set the Total mode of the expressions to Expression Default instead of Sum of Rows.
See if the attached helps.
As mentioned above, straight table properties, number
- check Show in % & Choose your number format
Or do you need the % of the total amoun?