Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum function problem

My problem is that i want to get the sum of my colums a and b but when i use the sum function to get the total of these columns in a textbox. I get a false total.

How can i bypass my problem and get the total of the colums in the textbox?Unbenannt.PNG

1 Solution

Accepted Solutions
sunny_talwar

Try it this way:

Sum(Aggr(If(BundgeProzent >100, 1, 0), yourChartDimensions))

list all dimensions where you see yourChartDimensions in the expression above

View solution in original post

1 Reply
sunny_talwar

Try it this way:

Sum(Aggr(If(BundgeProzent >100, 1, 0), yourChartDimensions))

list all dimensions where you see yourChartDimensions in the expression above