topic Re: Top 10 Values in QlikView

Top 10 Values

evansabres — Fri, 02 Jan 2015 20:08:34 GMT

Hello -

I have a data set that has names and values (points)

I want to create a list box that displays the top 10 users by points.

Is this possible?

Thank you.

Re: Top 10 Values

NickHoff — Fri, 02 Jan 2015 20:15:36 GMT

I'm not sure how to create exactly the top 10 users, but I've done something like this by instead of adding a field to the listbox, you add an if expression.

if(left(name,1)='A',name)

The above would display only the items in the listbox that start with an A.

For your used case maybe you can set a benchmark to display the users if they are over that benchmark.

After thinking about it some more you probably could order by the numbers and display count of 10.

Re: Top 10 Values

evansabres — Fri, 02 Jan 2015 20:17:45 GMT

I am hoping to create a list that will update every time the file is refreshed. Unfortunately, a benchmark wouldn't be too useful here because the top point users will continue (hopefully) to acquire points as will those who are not in the top ten.

Thank you,

Re: Top 10 Values

NickHoff — Fri, 02 Jan 2015 20:18:17 GMT

After thinking about it some more you probably could order by the numbers and display if count (distinct fieldname) <= 10.

Re: Top 10 Values

evansabres — Fri, 02 Jan 2015 20:21:36 GMT

would that be done in the Sort tab?

Re: Top 10 Values

NickHoff — Fri, 02 Jan 2015 20:23:00 GMT

Correct, the Sort tab > numeric value. Make sure to add a frequency so you can display the number with the users to verify.

Also, for your use case you might have to use aggr to group the results by user.

=aggr(if(rank(sum(fieldname for user))<=10,userpointfield),userpointfield)

Re: Top 10 Values

evansabres — Fri, 02 Jan 2015 20:29:03 GMT

where would that expression be entered

Re: Top 10 Values

NickHoff — Fri, 02 Jan 2015 20:31:31 GMT

In your listbox expression shown below: