Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Show highest value through Expression

Hello

I have found the percentages of certain values which I'm interested in

But I'm looking for an expressions to show the highest percentage based on a certain value in a KPI

i.e.

A = 10%

B = 20%

C = 5%

Show percentage of B

11 Replies
akpofureenughwu
Creator III
Creator III

Can you express this better?

ishanbhatt
Creator II
Creator II

Hello Michael,

Use below expression

=FirstSortedValue([Alphabet],-aggr(Max([Percentage]),[Alphabet]),1)

FirstSortedValue.PNG

Please note that here I've given Alphabet and percentage field name of your data.

Hopefully, this will help you.