Discussion Board for collaboration on QlikView Scripting.
I have straight table and I want divide a column with another column total. How can I do that in straight table?
Thanks for the help.
here is the picture
I want to divide the third column with second column total that is 2785
if the second column is sum(Expression2) and the third is sum(Expression3)
sum(Expression3) / sum(TOTAL Expression2)
Label name of column 3 / Label name of column 2
try this with optimization
hope this help you
Thanks & Regards
Sum(Column 3 Expression)/ Sum(Total Column 2 Expression)