IF Type Expression In Script to Create New Column

[aliyoung92]

Hi,

New to Qlikview so looking for some help.

In the script I have a column with various names, I want to make a new column which is basically an IF statement.

So if a value in column A equals a certain value, it is renamed in Column B.

Company                         Area Manager

Company A                       Bob Smith

Company B                       Susan Jones

Company C                       Bob Smith

Company D                       Susan Jones

I.e IF Company Column equals Company A or C Create Area Manager Column and give name of Bob Smith

Thanks in advance.

[sunny_talwar]

May be like this:

If(Match(Company, 'Company A', 'Company C'), 'Bob Smith', False Statement) as [Area Manager]

or you can use something like this: Data Cleansing

[MK9885]

if(Company=Company,[Area Manager])

But the end result will be same as your Original Area Manager column. I don't know whats the purpose to create this?

Unless you want to eliminate other managers and only consider Bob Smith. Then you can use Sunny's expression.