Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
joeybird
Contributor III

double null flag

Hiya

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

Please help

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: double null flag

if(len(trim(Depot))=0 and len(trim(Factory))=0, 1,0) as DoubleNullFlag


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: double null flag

if(len(trim(Depot))=0 and len(trim(Factory))=0, 1,0) as DoubleNullFlag


talk is cheap, supply exceeds demand
joeybird
Contributor III

Re: double null flag

Hiya

fab, all works thanks Gysbert!!