Discussion board where members can get started with Qlik Sense.
I'm do a script load where the latest date is pulled from the source using Max(Alert_Date). Cant seem to make this work.
T2:LOADD_Number,Alert_Title,Alert_Date,Alert_Type,Resident T1Where Alert_Type = 'Structured' and Alert_Date = Max(Alert_Date);
max will not work that way.
you will need to load max into another temporary table
LOADMax(Alert_Date) as MaxALERTDate,Resident T1Where Alert_Type = 'Structured' ;
use peek to get the max date into a variable
let vtemp=Peek('MaxALERTDate', 0, 'Temp')
and use that variable in the where clause
View solution in original post
You can also try this:
Max(Alert_Date) as Alert_Date,
Group by D_Number, Alert_Title, Alert_Type
Where Alert_Type = 'Structured';
Thanks! That did the trick