topic Re: Max with Firstsortedvalue in QlikView

Max with Firstsortedvalue

QlikAngel — Wed, 06 Apr 2016 15:59:55 GMT

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..

Re: Max with Firstsortedvalue

sunny_talwar — Wed, 06 Apr 2016 16:03:14 GMT

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))

Re: Max with Firstsortedvalue

QlikAngel — Wed, 06 Apr 2016 17:09:29 GMT

if i want sequentially previous PO then ?

Re: Max with Firstsortedvalue

sunny_talwar — Wed, 06 Apr 2016 17:13:28 GMT

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

Re: Max with Firstsortedvalue

QlikAngel — Wed, 06 Apr 2016 17:32:55 GMT

Hi Sunny,

Thanks a ton .. its working..

Re: Max with Firstsortedvalue

sunny_talwar — Wed, 06 Apr 2016 17:35:06 GMT

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