topic Sum a group in QlikView

Sum a group

Wed, 08 Feb 2017 19:30:25 GMT

Hello

I thought this is doable with set analysis but I cannot seem to find a way.

I need Sum(Score) for Study ID when a user has selected one of the User ID.

In this data, a user may select Last Name = b. The last name b has study ID =1 so in that case I need the sum of score to be 7.

If a user selects Last Name = d; that has study ID 1 and 2. So the Sum needs to be 15.

How to do that?

Thanks

sunny_talwar — Wed, 08 Feb 2017 19:38:18 GMT

May be this:

Sum({<[Last Name], [Study ID] = P([Study ID])>}Score)

Wed, 08 Feb 2017 19:51:47 GMT

Worked like a charm. I included the other columns and it works perfectly.

Sum({<[User ID], [First Name], [Last Name], [Study ID] = P([Study ID])>}Score)