Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: Sum function problem

Try it this way:

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

list all dimensions where you see yourChartDimensions in the expression above

1 Reply
sunny_talwar
Not applicable

Re: Sum function problem

Try it this way:

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

list all dimensions where you see yourChartDimensions in the expression above