Show a value based on the max of another value

[Anonymous]

Hello,

I am new to Qlikview and having issues with something.  I am wanting to show a unit cost based on the last purchase date of a product/po.

We have a table that has po number, product code, po date, unit cost etc.  these are all individual lines in the table and what I want to do is show a new field as the last purchase cost based on the date and product code.

so if I have:

po number      product code     po date          unit cost

1                    product A          1/20/2016     50

2                    product A          2/20/2016     45

what I would want is:

po number     product code     po date          unit cost     last purchase cost

1                    product A          1/20/2016     50               45

1                    product A          2/20/2016     45               45

this is in a straight table.  Just curious if this can be done.

Thanks
Brandon

[sunny_talwar · Accepted solution]

May be this:

FirstSortedValue(TOTAL <[product code]> [unit cost], -[po date])

[Anonymous]

That seems to have worked.  Thanks for the quick help.