topic put into a text object the best customer in QlikView

put into a text object the best customer

Wed, 29 Jul 2009 18:29:28 GMT

Hi all,

I post here my model:

I wish to extract the CustomerCode corresponding to max(sum({$<Type={'P'}>} [Sales Amount]) )

Can anyone help me?

Thanks a lot!

Wed, 29 Jul 2009 19:47:50 GMT

Hi Roberta,

Here you are:

=aggr(if(max(total aggr(sum({$<Type={'P'}>} [Sales Amount]),Customer))=sum({$<Type={'P'}>} [Sales Amount]),Customer),Customer)

Regards

Karol

Wed, 29 Jul 2009 20:40:26 GMT

Thanks Karol!

It works well!

Roberta