Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasa1
Creator II
Creator 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


.



3 Replies
Gysbert_Wassenaar

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
qlikdeez
Specialist
Specialist

See if the attached helps.

As mentioned above, straight table properties, number

- check Show in % & Choose your number format

qlikdeez
Specialist
Specialist

Or do you need the % of the total amoun?

i.e

PercOfTotal.PNG