# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor II

## Re: Percent in column

PFA

sum(cost_eur) / sum(total cost_eur)

Hope this helps.

Contributor III

## Re: Percent in column

see attached...

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

Valued Contributor II

## Re: Percent in column

Oops, my percentages  are not correct

Sorry!

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.

Valued Contributor II

## Re: Percent in column

Cannot find attached file...

New Contributor II

## Re: Percent in column

Can i send you this file directly?

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))

New Contributor II