Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to display name with highest score

I want to make a table which displays the name with the highest score of each exercise. The data is loaded from an excel spreadsheet like this:

exercisenamepoints
exercise1nameA10
exercise1nameB23
exercise1nameC40
exercise2nameA16
exercise2nameB12
exercise2nameC6
exercise3nameA4
exercise3nameB8
exercise3nameC5

This is how I want the result table to look like:

Exercisewinnerpoints
exercise1nameC40
exercise2nameA16
exercise3nameB8

I am using exercise as dimention and max(points) for points, but how do i set up the expression for winner?

Tags (1)
1 Solution

Accepted Solutions
flipside
Not applicable

Re: How to display name with highest score

Try

=FirstSortedValue(name,-points)

flipside

3 Replies
flipside
Not applicable

Re: How to display name with highest score

Try

=FirstSortedValue(name,-points)

flipside

IAMDV
Not applicable

Re: How to display name with highest score

Hi,

I understand you have the answer you needed. However, if you are keen to learn more about FirstSortedValue() then look at my blog. I have made a series of video tutorials on this topic.

http://qlikshare.com/tag/firstsortedvalue

Happy learning!

Cheers,

DV

Not applicable

Re: How to display name with highest score

If you are using a chart, you can also do it with Dimension Limits. You can filter your data with your first expression in the chart. There are many different way to filter in Dimension Limits section on Chart Properties by your first expression.