Discussion board where members can get started with QlikView.
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:
This is how I want the result table to look like:
I am using exercise as dimention and max(points) for points, but how do i set up the expression for winner?
Go to Solution.
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.
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.