topic Re: If Field is Null return other field value in QlikView

If Field is Null return other field value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I am trying to bring in data from a table with the below fields in my edit script

Product_Code

Product_Name

Product_DESCR

I only really need the Product_Code and Product_DESCR, however not every Product Code has a Product DESCR. In the case where there is no product DESCR is there a way to write the script that if the Product DESCR is blank (No Value at all) that the script will return the Product Name as the Product_DESCR?

Thanks,

Re: If Field is Null return other field value

Mon, 20 Feb 2017 10:03:39 GMT

Try like this

if(isnull(Product_DESCR),Code,Product_DESCR) as data

Re: If Field is Null return other field value

adamdavi3s — Mon, 20 Feb 2017 10:05:32 GMT

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

Re: If Field is Null return other field value

Anonymous — Mon, 20 Feb 2017 12:00:50 GMT

Hi Guys,

Both your examples work well, only change I had to make was the second Product_DESCR needed replaced with Product_NAME

if(len(Product_DESCR)<1,Prodct_Code,Product_Name) as data

if(isnull(Product_DESCR),Product_Code,Product_Name as data

Cheers.

Re: If Field is Null return other field value

Tue, 21 Feb 2017 04:31:05 GMT

Can you elaborate more,

am not getting what are you asking here

Re: If Field is Null return other field value

roccosdg — Tue, 06 Nov 2018 18:55:16 GMT

Can you create tiers of this. Example Below:

If [Field A] is null,

Use [Field B],

If [Field B] is null,

Use [Field C].

Syntax would be helpful! Thanks

Re: If Field is Null return other field value

adamdavi3s — Mon, 20 May 2019 17:22:08 GMT

if(len(A)>0,A,if(len(B)>0,B,if(len(C)>0,C,'DEFAULT'))) as data

Re: If Field is Null return other field value

Saravanan_AKS — Wed, 29 Jan 2020 03:06:19 GMT

What if don't defined the 3 part in if condition while using in load statement ..

Ex: if (isnull(item), qty)

whether will return the item for not null values

Re: If Field is Null return other field value

Midastouch365 — Thu, 11 Nov 2021 17:36:35 GMT

What if I have multiple parameters to pass in? How will I write that?

In this scenerio, only Product_Code and Product_Descr are passed in. Can I pass more than two parameters?