topic Choose the latest date in QlikView

Choose the latest date

Fri, 07 May 2010 02:28:08 GMT

Hi all,

I got problem,

That is, how can i choose the latest date from the source.

The File structure will be like that.

I want to extract the record is Only Item A (6/5/2010) and Item B (5/5/2010)

Thanks and Best Regards,

kzorrw

Fri, 07 May 2010 07:52:02 GMT

Hi,

you can use the following code

tab1:

LOAD * INLINE [

Item, Date, Price

A, 1/5/2010, 12

A, 3/5/2010, 15

A, 6/5/2010, 16

B, 1/5/2010, 1

B, 5/5/2010, 3

];

load Item,max(Date) as maximum resident tab1 group by Item;

it should work fine

thanks

Fri, 07 May 2010 08:03:51 GMT

Thanks a lot for your reply.

Your code work well.

Thanks