topic Re: Getting the most record record in QlikView

Getting the most record record

Fri, 12 Apr 2013 13:20:21 GMT

I was wondering if someone could help me with this.

I have the following data

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

Thanks

Andy

kaushiknsolanki — Fri, 12 Apr 2013 13:39:15 GMT

Hi,

Try this expression.

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

Add dimension as Item_Code.

This will give you latest record.

Regards,

Kaushik Solanki

Fri, 12 Apr 2013 14:02:23 GMT

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

Thanks

Andy

Fri, 12 Apr 2013 15:04:13 GMT

try this

Fri, 12 Apr 2013 16:07:42 GMT

Hi ,

Try the below Code

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

Resident Table Group by ItemCode Order by Date .