topic Re: Max function with conditon in QlikView

Max function with conditon

Anonymous — Wed, 17 May 2017 14:34:37 GMT

Hi ,

Can anyone help me in finding

Max Item_Sold made by the salesman in each company?

Result is given below in the table.

For Input please find the attachment.

Anonymous — Wed, 17 May 2017 14:38:36 GMT

Sorry the result I want is

Anil_Babu_Samineni — Wed, 17 May 2017 14:44:00 GMT

May be this?

FirstSortedValue(Iteam_Sold, -Aggr(Sum(Iteam_Sold), Sales_Man))

Anil_Babu_Samineni — Wed, 17 May 2017 14:45:42 GMT

And If you want to exact outcome use this

First Expression

FirstSortedValue(Sales_Man, -Aggr(Sum(Iteam_Sold), Sales_Man))

Second expression same in above

Anonymous — Wed, 17 May 2017 14:58:28 GMT

Thanks, Anil

It's working fine

Anil_Babu_Samineni — Wed, 17 May 2017 15:00:24 GMT

Excellent, Please close this thread by flag of Correct Answer

daveamz — Wed, 17 May 2017 15:03:32 GMT

Hi,

I prefer creating a flag in the script. You have more control over the output and also it is easier to debug.

Check the attach.

Regards,

David