Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
neena123
Partner
Partner

If dimension is null then show other field

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?

Labels (3)
1 Solution

Accepted Solutions
neena123
Partner
Partner
Author

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

View solution in original post

8 Replies
Vegar
MVP
MVP

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

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
neena123
Partner
Partner
Author

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

Vegar
MVP
MVP

Could it be that  it is not an null value?

Try this:

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
neena123
Partner
Partner
Author

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

Vegar
MVP
MVP

It could be just an empty string, ''.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
neena123
Partner
Partner
Author

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

View solution in original post

Vegar
MVP
MVP

That's great!

 

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

 

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Timothy958
Contributor
Contributor

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