Max with Firstsortedvalue

[QlikAngel]

Hi,

I want to add below expression , below expression is working .. but want to add in below expression stating if PO_NUMBER is Max on selection of Year or Month then only below expression should work.

=FirstSortedValue( DISTINCT Aggr(SUM({<PODTL_PHA_CREATION_YEAR = {$(vMaxYear)},PODTL_PHA_AUTHORIZATION_STATUS = {"APPROVED"} >}DISTINCT PODTL_PLA_UNIT_PRICE),

PODTL_ORGANIZATION_NAME,NEW_PODTL_ITEM_CODE,PODTL_ITEM_CODE,PODTL_PHA_CREATION_DATE),-(PODTL_PHA_CREATION_DATE),1)

how to do it please help..

[sunny_talwar · Accepted solution]

Not sure I understand, but may be this:

If(Max(PO_NUMBER) = Max({1} PO_NUMBER),

FirstSortedValue( DISTINCT Aggr(SUM({<PODTL_PHA_CREATION_YEAR = {$(vMaxYear)},PODTL_PHA_AUTHORIZATION_STATUS = {"APPROVED"} >}DISTINCT PODTL_PLA_UNIT_PRICE),

PODTL_ORGANIZATION_NAME,NEW_PODTL_ITEM_CODE,PODTL_ITEM_CODE,PODTL_PHA_CREATION_DATE),-(PODTL_PHA_CREATION_DATE),1))

[QlikAngel]

if i want sequentially previous PO then ?

[sunny_talwar]

Not sure I understand, can you share a sample with expected output?

[QlikAngel]

Hi Sunny,

Thanks a ton .. its working..

[sunny_talwar]

I am amazed it does, because I seriously had no clue about what you wanted. Well I had some clue, but was not 100% sure