Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vipin_mishra479
Contributor 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
aadilmadarveet
Valued Contributor

Re: How to get Maximum number customer name

you can use this..

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

2 Replies
aadilmadarveet
Valued Contributor

Re: How to get Maximum number customer name

you can use this..

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

Not applicable

Re: How to get Maximum number customer name

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

Community Browser