Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Trying to return value if another value is the maximum

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?

1 Reply

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

HI

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

Community Browser