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: 
vipin_mishra479
Creator II
Creator II

How to get Maximum number customer name

hi i am uploading qvw file in this file there have 2 field customer and amount

i get the minimum amount and customer name in text box but

how to get max amount customer name in textbox

1 Solution

Accepted Solutions
Anonymous
Not applicable

you can use this..

=MaxString({<Amount = {$(=Max(Amount))}>}Customer)

View solution in original post

2 Replies
Anonymous
Not applicable

you can use this..

=MaxString({<Amount = {$(=Max(Amount))}>}Customer)

Not applicable

Hi Vipin

1. Create one variable (Var=Max(Amount))

2. Use: MaxString(if(Amount=Var,Customer)) in your text box

Hope it helps!

Thanks,

Attitude