topic Re: Flag Max Date in QlikView

Flag Max Date

Anonymous — Thu, 17 Jul 2014 09:34:45 GMT

Hi All,

I have a table with items and dates it looks like that:

I wish to add a flag to indicate the max date for each item

appreciate any help

thanks

avner

alexandros17 — Thu, 17 Jul 2014 09:47:21 GMT

Where in the script or in a chart?

In the script do:

AAA:

Select Item, myDate from myTable;

left join

Load Item, Max(myDate) as myFlag resident AAA group by Item;

Let me know

parthiband — Thu, 17 Jul 2014 10:00:31 GMT

The script which Alexandros17 posted is right.

But for your better understanding, it will be much better if u use the below

AAA:

LOAD Item,

myDate,

Item&Num(Date) as Key

FROM myTable;

left join (AAA)

LOAD Item&Num(MaxDate) as Key, 1 as Flag;

Load Item,

Max(myDate) as MaxDate

resident AAA

group by Item;

Drop Field Key;

Thanks,

VishalWaghole — Thu, 17 Jul 2014 10:21:58 GMT

Hi Anver,

PFA Hope it will help you.

-- Regards,

Vishal Waghole

Anonymous — Thu, 17 Jul 2014 10:57:45 GMT

Thanks

it really helped me