topic Re: Fill blank within an if expression. in App Development

Fill blank within an if expression.

robin_heijt — Wed, 22 Aug 2018 16:41:11 GMT

Hi,

My current syntax in my data load editor is this:

Load*,If("LM" ='N/A N/A','Vacant',"LM") as "Line Manager",

If("LM -1" ='N/A N/A','Vacant',"LM -1") as "Line Manager -1";

This will change the N/A (Black line) into Vacant which works fine for me.

Now I also have blank spaces (Yellow) next to N/A(See below):

How can I adapt the load editor to not only fill up N/A with Vacant, but also to fill the blanks with Vacant?

Thanks

Re: Fill blank within an if expression.

Anonymous — Wed, 22 Aug 2018 16:49:16 GMT

Blanks are null()

so:

If (LM = null() ,

this will check if the fields are blank

the opposite would be:

LM <> null()

with those you can achieve what you want.

If you want a more clear answer, please explain more what you want to do.

Like, Mark as helpful and mark as correct if it is, it helps a lot!

Thanks

Re: Fill blank within an if expression.

robin_heijt — Thu, 23 Aug 2018 09:27:13 GMT

Thank you for your response, however I am still a little bit unclear as to what to do.

I want to use these if statements:

Load*,If("LM" ='N/A N/A','Vacant',"LM") as "Line Manager",

If("LM -1" ='N/A N/A','Vacant',"LM -1") as "Line Manager -1";

But in addition, I do not only want N/A N/A to be replaced by vacant, but also null values to be replaced by vacant.

How would I have to change my if statement to include this extra requirement.

Thanks.

Re: Fill blank within an if expression.

ValeriyaBartosh — Thu, 23 Aug 2018 11:34:41 GMT

Load*,If("LM" ='N/A N/A' or isnull("LM"),'Vacant',"LM") as "Line Manager",

If("LM -1" ='N/A N/A' or or isnull("LM-1"),'Vacant',"LM -1") as "Line Manager -1";

Re: Fill blank within an if expression.

Anonymous — Thu, 23 Aug 2018 12:21:59 GMT

This should be what you want.

The statement OR will make your if statement true if any of those checks are true. But will only be false if all of them are false.

Load*,If("LM" ='N/A N/A' or "LM" =null(),'Vacant',"LM") as "Line Manager",

If("LM -1" ='N/A N/A' or "LM -1" = null(),'Vacant',"LM -1") as "Line Manager -1";

if you want more complex statements in the future, you can also put an if inside another.

Like, Mark as helpful and mark as correct if it is, it helps a lot!

Thanks

Re: Fill blank within an if expression.

BalaBhaskar_Qlik — Thu, 23 Aug 2018 15:10:17 GMT

Load *,

If(Match("LM",'N/A N/A',''),'Vacant',"LM") as "Line Manager",

If(Match("LM -1",'N/A N/A',''),'Vacant',"LM -1") as "Line Manager -1";