Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to make IntervalMatch work in my script on Qlik Sense. I have other IntervalMatch and they are all working fine, but this last one keeps throwing an error.
My script:
Qualify *;
Unqualify 'key*';
NoConcatenate
Priorita:
LOAD *
Resident Priorita_temp_last
;
Unqualify *;
Call Anagrafica('Mandati','');
Left Join IntervalMatch ( Mandati.DataIns, Mandati.CU )
LOAD Priorita.ValiditaAl, Priorita.ValiditaDal, Priorita.CU
Resident Priorita;
The Call Anagrafica('Mandati',''); just calls a function that calls the specified table.
The error is that the columns Priorita.ValiditaAl, Priorita.ValiditaDal, Priorita.CU are not found.
I've tried with some debug to save the Priorita QVD and then exit the script in order to check if the columns are there, and they actually are, so I totally don't understand why it can't found them when using the IntervalMatch.
Thanks
Try and create a dummy field on the load script after the left join, like:
Left Join IntervalMatch ( Mandati.DataIns, Mandati.CU )
LOAD Priorita.ValiditaAl, Priorita.ValiditaDal, Priorita.CU, 1 as dropfield
Resident Priorita;