Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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