topic IF Type Expression In Script to Create New Column in QlikView

IF Type Expression In Script to Create New Column

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

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 — Wed, 07 Dec 2016 16:03:42 GMT

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 — Wed, 07 Dec 2016 16:29:40 GMT

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.