Discussion board where members can learn more about Qlik Sense App Development and Usage.
I wish to produce a null flag in the data load
this works for 1 column on a record
If(len("Depot"),0, 1) AS NullFlag,
how do I produce a flag for each record if 2 columns in a row are null?
e.g Depot is null and Factory is null
Go to Solution.
if(len(trim(Depot))=0 and len(trim(Factory))=0, 1,0) as DoubleNullFlag
fab, all works thanks Gysbert!!