Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
FirstSortedValue(TOTAL <[product code]> [unit cost], -[po date])
May be this:
FirstSortedValue(TOTAL <[product code]> [unit cost], -[po date])
That seems to have worked. Thanks for the quick help.