topic Re: Null Value in QlikView

Null Value

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can someone tell me what this formula means? I want to say if phone1 is null or has 'no number' listed then phone4 else phone1 but this formula seems to provide with no match (all grayed out) even though the phone1 has number within.

If(Len(Trim(phone1 )) = 0 or phone1 = 'no number', phone4, phone1) as Phone_Numbers

Thanks in Advance,

Re: Null Value

sunny_talwar — Thu, 17 Mar 2016 20:27:57 GMT

That is weird are you somehow adding more phone1 after this if statement in your script?

Re: Null Value

avinashelite — Thu, 17 Mar 2016 20:30:23 GMT

you expression is write .. its checking for the null or no number content if found its populating the phone4 else phone1. where your making the selection means which field ??

Did you scroll your Phone_Number list box till the last and checked ?? because some times due to sorting it might be at the last

Re: Null Value

Thu, 17 Mar 2016 20:34:10 GMT

Thanks Sunny, I had gotten this formula from the community. One person had recommended the alt formula

alt (phone1, phone4) as Phone Number

instead of

If(Len(Trim(phone1 )) = 0 or phone1 = 'no number', phone4) as Phone_Numbers

so I also tried it but that also gives a weird response.

Re: Null Value

sunny_talwar — Thu, 17 Mar 2016 20:38:48 GMT

The formula itself is not wrong, it seems that the timing of when you use it may be a little off. Can you share your script?

Re: Null Value

Thu, 17 Mar 2016 20:48:50 GMT

Thanks for the response guys, Please find attached the sample data set

Re: Null Value

swuehl — Thu, 17 Mar 2016 21:38:30 GMT

In your script, you've written

If(Len(Trim(phone1 )) = 0 or phone1 = 'no number', phone4) as Phone_Numbers,

Compare to the suggested line:

If(Len(Trim(phone1 )) = 0 or phone1 = 'no number', phone4, phone1) as Phone_Numbers

Are both the same?

Re: Null Value

Thu, 17 Mar 2016 21:50:49 GMT

Sorry you're right Stefan they're definitely not the same. Thanks got the solution, thanks for all your help.

Re: Null Value

swuehl — Thu, 17 Mar 2016 21:53:25 GMT

No problem, glad that it works.