Discussion board where members can get started with Qlik Sense.
I am looking for some help on how to obtain the most recent price of an item that has been purchased multiple times. I want to display the price based on the Max date in a table. My raw data set looks like below.
And what i would like to display would be below:
[PO Date] ,
Right join (Prices)
Max([PO Date]) as [PO Date],
I think you could use FirstSortedValue.
FirstSortedValue(Item, -PO Date) would show the first value of Item based on the max date.
I would create a table with the following columns:
PO DateFirstSortedValue(Item, -PO Date)PO DescrPrice
In a straight table create as below:
Hope this helps.
Value should be 2348.18 as that is the newest price for that Item ID