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: 
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