topic Nested IF statement help in QlikView

Nested IF statement help

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I'm trying to do a nested if condition. I want to say if......phone1 is null or phone1 is 'no number' then provide me with the phone4 else phone1.

If(Len(Trim(phone1 )) >0 or phone1 = 'no number', phone4, phone1) as Phone_Number.

Please provide assistance,

Thanks

Re: Nested IF statement help

swuehl — Mon, 14 Mar 2016 19:52:39 GMT

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

Re: Nested IF statement help

Mon, 14 Mar 2016 19:57:35 GMT

Thanks for the reply. Whats the difference between using = compared to > both would eliminate the null wouldn't it?

Re: Nested IF statement help

sunny_talwar — Mon, 14 Mar 2016 20:00:29 GMT

May be this:

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

Re: Nested IF statement help

maxgro — Mon, 14 Mar 2016 20:02:23 GMT

alt(phone1, phone4) as Phone_Number

alt(case1[ , case2 , case3 , ...] , else)

The alt function returns the first of the parameters that has a valid number representation. If no such match is found, the last parameter will be returned. Any number of parameters can be used.

Re: Nested IF statement help

swuehl — Mon, 14 Mar 2016 20:07:23 GMT

If phone1 is an empty string, a string with only spaces or NULL, Len(Trim(phone1)) will return zero.

I think that's what you want to test for, right?

Re: Nested IF statement help

Mon, 14 Mar 2016 20:10:10 GMT

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

So when it returns no number even after this function it means both phone1 and phone4 have no number (contains no number on file) for the specific selection in the list box right?

Thanks guys,