topic Need help with this table in QlikView

Need help with this table

Thu, 24 Dec 2015 15:49:13 GMT

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

maxgro — Thu, 24 Dec 2015 17:06:31 GMT

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

sum(Expression3) / sum(TOTAL Expression2)

settu_periasamy — Sat, 09 Jan 2016 08:31:25 GMT

Column(3)/Column (2)

Label name of column 3 / Label name of column 2

ahmar811 — Sat, 09 Jan 2016 08:49:51 GMT

try this with optimization

column(1)/sum(Total Expression2)

hope this help you

Thanks & Regards

Ahmar Ansari

HirisH_V7 — Sat, 09 Jan 2016 11:32:00 GMT

Hi,

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

HTH,

Hirish