Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
maxgro
MVP
MVP

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

sum(Expression3) / sum(TOTAL Expression2)

settu_periasamy
Master III
Master III

Or

Column(3)/Column (2)

Or

Label name of column 3 / Label name of column 2

ahmar811
Creator III
Creator III

try this with optimization

column(1)/sum(Total Expression2)

hope this help you

Thanks & Regards

Ahmar Ansari

HirisH_V7
Master
Master

Hi,

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

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”