Discussion Board for collaboration on QlikView Scripting.
I have question to ask
sample table like this (format date : mm/dd/yyyy):
ID Name Date
1 John 1/6/2011
1 John 3/2/2011
1 John 4/20/2011
2 Andy 2/1/2011
3 Jean 3/3/2011
3 Jean 4/7/2011
4 Chris 1/1/2011
what i want is to load the table where the date is maximum date like this :
how to solve it? thanks all
see also this example for help (Solution by script and by expression in a table)
View solution in original post
Use max function with group by clause to get the reuslt.
Load ID, Name, Date(Max(Date),'mm/dd/yyyy') as Date
from table group by ID, Name;
You can load only Max dates by using the script below
Date(Max(Date),'mm/dd/yyyy') as Date
GROUP BY ID, Name;
You can use
Max(Date) in the expression, by using ID and Name as Dimensions.