Calculating Percentage

[#1]

Hi All,

I want to find the percentage of each item with respect to total in table.Can u please let me knw the solution

for eg A is 10% of Price

C is 5% of Price

[Gysbert_Wassenaar · Accepted solution]

You can enable the option Relative for the expression sum(Price) or you can use sum(Price)/sum(total Price). See attached qvw.

[#3]

can u please tell me what does sum(total price) means?????

[qliknerd]

It means the total sum of all the column so if you had three values 10, 20 and 30 in the price column, sum(TOTAL price) would be 60.