I have the following table in Qlik that I need to add two more columns to. I'm struggling a bit with the syntax, either in the script or within the expression of a table.
I need one line per scheme that shows;
SchemeNo - Max(CompletedDate) - Next Due - Next Due+1
F47478 10/08/2020 01/12/2020 01/03/2021
Can anyone suggest how I can achieve this please?
Help is much appreciated.
@samvile18 One solution :
Input table :
load * inline [
load [Sheme Number],Date(Max(CompletedDate,1)) as [Max CompletedDate] resident Input where len(trim(CompletedDate))>0 group by [Sheme Number];
load [Sheme Number],Date(Min(DueDate,1)) as [Next Due],Date(Min(DueDate,2)) as [Next Due+1] resident Input where len(trim(CompletedDate))=0 group by [Sheme Number];
drop table Input;
View solution in original post
Yep - outstanding, thanks very much for your time.