topic Logic help in QlikView

Logic help

Fri, 26 Feb 2016 07:17:33 GMT

Here I want to rename NAME Column for ID 284 and 285 with Type = Our Sublet

if(ID = 284 and Name = ' Holdings Limited' ,'Oil Price Information',

If (ID =285 and NAME = 'Oil Price Information','Communications Limited',NAME))

This logic is not working.How can I write it in a diff way ?

sunny_talwar — Fri, 26 Feb 2016 07:20:23 GMT

NAME is not consistent in your expression. May be this:

if(ID = 284 and NAME = 'Holdings Limited' ,'Oil Price Information',

If (ID =285 and NAME = 'Oil Price Information','Communications Limited',NAME))

or may be this:

If(ID = 284 and WildMatch(NAME, '*Holdings Limited*'), 'Oil Price Information',

If(ID = 285 and WildMatch(NAME, '*Oil Price Information*'), 'Communications Limited', NAME))

Fri, 26 Feb 2016 13:04:10 GMT

It was typo here,but in the script it is consistent.

sunny_talwar — Fri, 26 Feb 2016 13:08:13 GMT

Did you try my WildMatch suggestion? May be there are unknown spaces before or after the text?

alexandros17 — Fri, 26 Feb 2016 13:17:53 GMT

Try with

if(ID = 284 and Trim(NAME) = ' Holdings Limited' ,'Oil Price Information',

If (ID =285 and Trim(NAME) = 'Oil Price Information','Communications Limited',NAME)) as NAME

let me know