Discussion board where members can get started with QlikView.
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
The script which Alexandros17 posted is right.
But for your better understanding, it will be much better if u use the below
Item&Num(Date) as Key
left join (AAA)
LOAD Item&Num(MaxDate) as Key, 1 as Flag;
Max(myDate) as MaxDate
group by Item;
Drop Field Key;
View solution in original post
Where in the script or in a chart?
In the script do:
Select Item, myDate from myTable;
Load Item, Max(myDate) as myFlag resident AAA group by Item;
Let me know
PFA Hope it will help you.
it really helped me