topic Bucket using a count of a sum in QlikView

Bucket using a count of a sum

mellerbeck — Thu, 04 Dec 2014 19:43:27 GMT

This should be easy, but can't wrap my mind around it

Have four users

LOAD * INLINE [

User, SCORE

1, 3

2, 4

1, 4

3, 1

4, 1

5, 1

];

Would like how many users have a 1 for the score etc.. so would be like

NumUsers Score

3 1

1 4

1 7

JonnyPoole — Thu, 04 Dec 2014 19:57:45 GMT

I loaded the data but got a different result.

Score is the dimension and count(distinct user) is the expression. I validated the results with the list of users that fall into each category .

What am i doing wrong ?

mellerbeck — Thu, 04 Dec 2014 20:00:26 GMT

user 1 has two scores, a value of 3 and a value of 4 so the score would be 7. Sorry didn't explain that very well in the initial question.

So, want the count of how many users have a score of X, and the 'score' is the sum of the scores.

JonnyPoole — Thu, 04 Dec 2014 20:05:01 GMT

gotcha, so the dimension becomes a 'calculated dimension' with the following formula:

=aggr(sum(SCORE),User)

JonnyPoole — Thu, 04 Dec 2014 20:10:37 GMT

mellerbeck — Thu, 04 Dec 2014 20:11:33 GMT

Yes! Gah it looks like case sensitivity was hurting me

I had =aggr(sum(SCORE),user)

with a lowercase u for user!