topic Sum values based on ID in QlikView

Sum values based on ID

samantha92 — Wed, 25 Nov 2020 16:16:04 GMT

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

sunny_talwar — Wed, 14 Jun 2017 13:28:57 GMT

May be this

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

samantha92 — Wed, 14 Jun 2017 13:58:57 GMT

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 — Wed, 14 Jun 2017 14:01:13 GMT

May be this

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

samantha92 — Wed, 14 Jun 2017 14:03:47 GMT

That's fab thank you!!