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

[Murugesan]

Hello, 

If(

    IsNull(industry)or Len(industry) <1,

    industry,

    Industry_New)

The given solution is working fine, but it shows all the values are possible value  from the field(ex. industry) in the header search box.
In the below img, the industry is holding companies but in the search box it shows all the value

Is there any way to control this