Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Need help with this table

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

Untitled.png

4 Replies
MVP
MVP

Re: Need help with this table

if the second column is sum(Expression2) and the third is sum(Expression3)

sum(Expression3) / sum(TOTAL Expression2)

Re: Need help with this table

Or

Column(3)/Column (2)

Or

Label name of column 3 / Label name of column 2

ahmar811
Contributor III

Re: Need help with this table

try this with optimization

column(1)/sum(Total Expression2)

hope this help you

Thanks & Regards

Ahmar Ansari

hirishv7
Honored Contributor

Re: Need help with this table

Hi,

Sum(Column 3 Expression)/ Sum(Total Column 2 Expression)

HTH,

Hirish

Community Browser