topic Re: Max Customer Name in QlikView

Max Customer Name

vanderson009 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have below data,

Customer, Value

A, 20

A, 30

B, 10

B, 15

C, 40

I want to take max value by customer, then want to display from Customer name in text box from max table, like

A, 30

B, 15

C, 40

is the maximum values record. Now want to display max customer from max table like

C in Text box

Regards,

Villyee

Re: Max Customer Name

Anonymous — Mon, 20 Jun 2016 06:39:15 GMT

Hi Villyee,

Yo show max by customer:

=MAX(TOTAL <Customer> Value)

Yo show the max customer:

=Only({<Value={$(=Max(Value))}>}Customer)

Regards!

Re: Max Customer Name

Mon, 20 Jun 2016 06:43:50 GMT

Hi,

Please see attached

Re: Max Customer Name

susovan — Mon, 20 Jun 2016 06:47:05 GMT

Hi Villyee,

Its might be your requirement.

PFA for QVW file.

Re: Max Customer Name

yadav_anil782 — Mon, 20 Jun 2016 06:56:07 GMT

plz go to this link - Max Group By 2 fields

max and group by function will help in this .

Re: Max Customer Name

effinty2112 — Mon, 20 Jun 2016 07:10:49 GMT

Hi Villyvee,

This expression in a textbox

=concat(Aggr(Customer & ', ' & Max(Value),Customer),Chr(10))

will give you:

A, 30

B, 15

C, 40

=Concat({<Value={$(=Max(Value))}>}Customer,', ')

will return the customer with the highest value or if there is a tie it will return the names separated by a ','.

Regards

Andrew

Re: Max Customer Name

muthukumar77 — Mon, 20 Jun 2016 07:14:01 GMT

Hi,

You can use like this,

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

Re: Max Customer Name

kamal_sanguri — Mon, 20 Jun 2016 07:40:37 GMT

C in the text box or A.. If we do a group by A will have 50 value.. isn't it..?

Thanks,

-Kamal