Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Percent in column

Hi,

in a table chart there are two columns, sum and percent. How can i get percent in column per?

sum    per

961     100%

125       13%

532       55 %

Regards

Stefan

Labels (1)
14 Replies
salto
Specialist II
Specialist II

When you answer, click on the "use the advanced editor" link in the right part. It will let you upload a document.

Anonymous
Not applicable
Author

It's uploaded.

jagannalla
Partner - Specialist III
Partner - Specialist III

Label: Sum

Exp: Sum(cost_eur)/Sum({1} TOTAL cost_eur)

Go to number -> check Fixed to and Show percent %.

But it is not matching according to your requirement. What is the logic you want to follow here.

Anonymous
Not applicable
Author


Column A have sum overall columns below. B and C are proprtionatly.

Anonymous
Not applicable
Author


That's the right answer. Many thanks for your help.

Stefan