Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stefan_fischer
New Contributor II

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

1 Solution

Accepted Solutions
Not applicable

Re: Percent in column

this?

per = Sum(cost_eur)/MAX(total aggr(sum(cost_eur),structure_name))

14 Replies
salto
Valued Contributor II

Re: Percent in column

PFA

sum(cost_eur) / sum(total cost_eur)

Hope this helps.

michael_maeuser
Contributor III

Re: Percent in column

see attached...

i actually don´t know what your dimension sort was doing??

salto
Valued Contributor II

Re: Percent in column

Oops, my percentages  are not correct

Sorry!

stefan_fischer
New Contributor II

Re: Percent in column


That's fine, it works in my test-file, but in my original file there is something wrong. Please ckeck on attached file, thanks.

salto
Valued Contributor II

Re: Percent in column

Cannot find attached file...

stefan_fischer
New Contributor II

Re: Percent in column

Can i send you this file directly?

salto
Valued Contributor II

Re: Percent in column

No problem, but if you upload it more people will be able to help you. Is is a problem for you to upload it?

Not applicable

Re: Percent in column

this?

per = Sum(cost_eur)/MAX(total aggr(sum(cost_eur),structure_name))

stefan_fischer
New Contributor II

Re: Percent in column

how can i upload?

Community Browser