Getting the most record record

[#1]

Hi

I was wondering if someone could help me with this.

I have the following data

Date	Item Code	Price
01/01/2012	ITEM1	12
01/02/2012	ITEM1	24
01/03/2012	ITEM1	36
03/04/2012	ITEM1	40

Is there anyway in Qlikview where I can just read in the most recent record for each item.

Thanks

Andy

[kaushiknsolanki]

Hi,

     Try this expression.

     sum({<Date = {"$(=max(Date))"}>}Price)

     Add dimension as Item_Code.

     This will give you latest record.

Regards,

Kaushik Solanki

[#3]

Thats for the answer, but I was wondering if its possible to do this in the script.

Thanks

Andy

[#4]

try this

[#5 · Accepted solution]

Hi ,

     Try the below Code

Load FirstValue(Price) as Price , Max(Date) as Date

Resident Table Group by ItemCode Order by Date .