Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Milaf
Contributor III
Contributor III

ratio of the line-based calculation to the bottom sum

Hi everyone,

How can I get the addition ratio of the number I calculated next to the two dimension?  I have two dimension on the left and on the right I want to divide by the sum of these digits.

Measure Formula: SUM({<[Flag]={"0"}>} Quantity)

Exp: 80803/1135617 

I could not provide the display in the table for this rate calculation.

Milaf_0-1716817228187.png

Thank you.

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

This looks like it should be:

SUM({<[Flag]={"0"}>} Quantity) / SUM({<[Flag]={"0"}>} Total Quantity)

View solution in original post

2 Replies
Or
MVP
MVP

This looks like it should be:

SUM({<[Flag]={"0"}>} Quantity) / SUM({<[Flag]={"0"}>} Total Quantity)

Milaf
Contributor III
Contributor III
Author

Thank you, total function never came to my mind 🙂