Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
samantha92
New 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

Re: Sum values based on ID

May be this

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

View solution in original post

4 Replies

Re: Sum values based on ID

May be this

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

View solution in original post

samantha92
New Contributor III

Re: Sum values based on ID

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

Re: Sum values based on ID

May be this

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

samantha92
New Contributor III

Re: Sum values based on ID

That's fab thank you!!