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: 
samantha92
Contributor III
Contributor III

Sum values based on ID

Hi,

I am having an issue with creating the following expression.

I need to group together any individuals who have more than 1 row of data

I then need to sum a value and only show if it is more than 8.5

So far I have tried the following:

if(sum(XYZ>=8.5), XYZ

But this does not group together the total if a person has more than 1 row of data (null values are those with more than 1 row of data)

Hope this makes sense!

Any help is appreciated.

Thanks

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum({<Surname = {"=Sum(XYZ) >= 8.5"}>} XYZ)

View solution in original post

4 Replies
sunny_talwar

May be this

Sum({<Surname = {"=Sum(XYZ) >= 8.5"}>} XYZ)

samantha92
Contributor III
Contributor III
Author

Thank you that works great - one more question...

How would I take the value of those people who are over 8.5 and do a count?

Thanks

sunny_talwar

May be this

Count(DISTINCT {<Surname = {"=Sum(XYZ) >= 8.5"}>} Surname)

samantha92
Contributor III
Contributor III
Author

That's fab thank you!!