Discussion Board for collaboration on QlikView Layout & Visualizations.
in a table chart there are two columns, sum and percent. How can i get percent in column per?
532 55 %
Go to Solution.
per = Sum(cost_eur)/MAX(total aggr(sum(cost_eur),structure_name))
sum(cost_eur) / sum(total cost_eur)
Hope this helps.
i actually don´t know what your dimension sort was doing??
Oops, my percentages are not correct
That's fine, it works in my test-file, but in my original file there is something wrong. Please ckeck on attached file, thanks.
Cannot find attached file...
Can i send you this file directly?
No problem, but if you upload it more people will be able to help you. Is is a problem for you to upload it?
how can i upload?