Discussion board where members can get started with QlikView.
I have this example:
I am not able to create max approval column. for each agreement I need to put there approval with lastest date.
I need to do it in the script for my main table, to add this column for each agreement.
can you please help.
Script / UI ??
Not tested, But can u try this?
If(agreement = Previous(agreement), approval,'') as [max approval]
Load * from table;
LOAD approval, agreement, date, If(agreement = Previous(agreement), approval,'') as [max approval] Resident Table Order By date desc;
DROP Table Table;
its still returns both projects for each agreement even though it should return only 1 for each agreement
Oh, Is it? Then this should work
Right Join (Table)
LOAD agreement, Max(date) as date Resident Table Group By agreement;
Left Join (Table)
Load agreement,FirstSortedValue(approval, date) as [max approval] Resident Table Group By agreement;