Discussion board where members can get started with QlikView.
I have this table called Items:
Trying to add a new field, [Max Main], like so:
Logic for Max Main=Y is basically:
Main = 'Y'
Date = Max(Item Date)
For each Key
Was trying to add this to the load script -
'Y' as [Max Main]
Resident Items where [Item Date]=Max([Item Date]) and [Main]='Y'
Group by [Key];
But definitely wrong as getting an error in the load. Any help?
Go to Solution.
Hi, Mark. Try this
Max([Item Date]) as [Item Date],
Resident Items where [Main] = 'Y'
Group by [Key], [Main];
View solution in original post