topic Re: Load only fields where date is max date in QlikView

Load only fields where date is max date

mazacini — Wed, 21 Aug 2013 11:00:09 GMT

I have a table with Code and Date, where multiple Dates for any Code.

I want to load Code, Date but only where Date is the maximum Date for that Code.

So for above, it will load

Aug 20

Code	Date
A
B	Feb 3

Any ideas please?

Wed, 21 Aug 2013 11:06:32 GMT

You will need to create a temp table containing the max value, you then use the PEEK function to get the value to use later

Wed, 21 Aug 2013 11:09:06 GMT

You can do it in one step:

Table:

LOAD

Code,

Max(Date) as Date

FROM ...

GROUP BY Code;

If you have more fields in that table, you will need a second step:

Left Join (Table)

Load

Code,

Date,

...

From...

This will only join the data of Codes with Max DAte.