Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Name of maximum value

How can I get of the name of maximum value

1 Solution

Accepted Solutions
Partner
Partner

Are you not sorting by the individual values of Value? If you sort the individual values from biggest to lowest they are the same as doing it for sums of values. I think a correct way to do it is to use the expressions:

max:

=FirstSortedValue(Name,-aggr(sum(Value),Name))

and

min:

=FirstSortedValue(Name,aggr(sum(Value),Name))

View solution in original post

3 Replies
Not applicable

This can be done by FirstSortedValue.Please find the application file

Partner
Partner

Are you not sorting by the individual values of Value? If you sort the individual values from biggest to lowest they are the same as doing it for sums of values. I think a correct way to do it is to use the expressions:

max:

=FirstSortedValue(Name,-aggr(sum(Value),Name))

and

min:

=FirstSortedValue(Name,aggr(sum(Value),Name))

View solution in original post

Not applicable

thank you