Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.