If dimension is null then show other field

[neena123]

Hello,

I have a straight table that has address information on it.

I would like the dimension to say If(Address1) is null then display TAddress1 but it isn't working. This is my exact dimension 

=IF(([Address 1]=null()),TAddress1) 

What am I doing wrong?

[Vegar]

=IF(isnull([Address 1]),TAddress1) 

See https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/NULLF...

[neena123]

Yes, I should of put that down but I did try that already and it didn't work. Thanks Though!!

[Vegar]

Could it be that  it is not an null value?

Try this:

IF(len([Address 1])=0,TAddress1) 

[neena123]

That didn't work either. But what do you mean that it is not a real null value? 

[Vegar]

It could be just an empty string, ''.

[neena123 · Accepted solution]

Ok. I think this works for me. =IF(len([Address 1]=null()),TAddress1)  Thanks for the help!

[Vegar]

That's great!

If so, please mark this question as solved. That will guide other users right in the future.

[Timothy958]

As above, the only change I would make is not to use the isnull function which is a bit sketchy at times!

if(len(Product_DESCR)<1,Code,Product_DESCR) as data