topic Re: Creating a new field with IF statement in QlikView

Creating a new field with IF statement

Anonymous — Tue, 07 Apr 2015 10:15:53 GMT

I am working with data on universities. I have two fields for university name linked by an ID tied to the name. One field is much longer and I would like to create one field for name where if there is a value in 'name 1' it takes that but if 'name 1' is empty it takes the value for 'name 2'

ID	Name 1	Name 2
1	UNC	UNC
2	-	USC
3	UVA	-
4	-	UGA

Any advice on how to write that to create a new field for name?

Thanks

Re: Creating a new field with IF statement

agomes1971 — Tue, 07 Apr 2015 10:19:10 GMT

Hi,

in your load data

if(Name1='',Name2,Name1) as Name

HTH

André Gomes

Re: Creating a new field with IF statement

PrashantSangle — Tue, 07 Apr 2015 10:19:10 GMT

hi,

try like

if(isnull(Name 1) or len(trim(Name 1))=0,Name 2,Name 1) as Name

Regards

Re: Creating a new field with IF statement

stigchel — Tue, 07 Apr 2015 10:20:26 GMT

Something like:

Load....

....

if(len(Name1)>0,Name1,Name2) as Name

......

from....

Re: Creating a new field with IF statement

Anonymous — Tue, 07 Apr 2015 10:21:50 GMT

Hi ,

LOAD ID,

[Name 1],

[Name 2],

if(len([Name 1])>1,[Name 1],[Name 2]) as [Final Name]

from file1

Thanks

BKC

Re: Creating a new field with IF statement

Anonymous — Tue, 07 Apr 2015 10:30:20 GMT

Hope the attached qvw solves your problem

Re: Creating a new field with IF statement

Tue, 20 Oct 2015 03:20:35 GMT

How can we do the same but if the fields are in different tables?

Re: Creating a new field with IF statement

Tue, 20 Oct 2015 04:51:25 GMT

Hello,

if (Len([Name_1])>1,

[Name_1],

[Name_2]) as [UniversityName]

Zain.