topic Trying to return value if another value is the maximum in QlikView

Trying to return value if another value is the maximum

Thu, 30 May 2013 21:07:40 GMT

I was trying to do something like this:

if(Aggr(max(ModifiedDate), UserId, ReportStatus) ...but it's not working.

In pure English, what I am trying to do is return a User's report status if their Modified Date is the latest. Is something in my statement incorrect or am I approaching the problem incorrectly?

Re: Trying to return value if another value is the maximum

MayilVahanan — Thu, 30 May 2013 21:38:26 GMT

Try with Firstsortedvalue() function

Ex:

firstsortedvalue(ReportStatus, Orderdate) gets the UserId with the minumum orderdate

firstsortedvalue(ReportStatus, -Orderdate) gets the UserId with the maximum orderdate

Refer this link

http://community.qlik.com/message/342392#342392

Hope it helps