Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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 🙂