Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
Specialist
Specialist

Finding Dimension value for a aggregated value

Hi All ,

max(aggr(sum(Sales),Country))

Above expression  gives me max of sale (aggregated range) . But i want to display the country in a text box , which is having max  sales (using above expression) , . Please help me with the expression .

Also the expression for second highest and third highest country in separate text box . Need help on the expression .

I have attached data as well .

Thanks & Regards

Shekar

1 Solution

Accepted Solutions
sunny_talwar

For 2nd and 3rd highest, you can use this

2nd highest

FirstSortedValue(Country, -Aggr(Sum(Sales), Country), 2)


3rd highest

FirstSortedValue(Country, -Aggr(Sum(Sales), Country), 3)

View solution in original post

2 Replies
sunny_talwar

Try this

FirstSortedValue(Country, -Aggr(Sum(Sales), Country))

sunny_talwar

For 2nd and 3rd highest, you can use this

2nd highest

FirstSortedValue(Country, -Aggr(Sum(Sales), Country), 2)


3rd highest

FirstSortedValue(Country, -Aggr(Sum(Sales), Country), 3)