topic How to get Maximum number customer name in QlikView

How to get Maximum number customer name

vipin_mishra479 — Wed, 01 Aug 2012 05:51:08 GMT

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

Anonymous — Wed, 01 Aug 2012 06:28:13 GMT

you can use this..

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

Wed, 01 Aug 2012 07:25:32 GMT

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