topic Re: If statment in load script with set value in QlikView

If statment in load script with set value

Thu, 03 Mar 2016 10:59:48 GMT

I want to separate the customers from clients by ActorEmployee_ID. So if a person has a ActorEmployee_ID that is in vSupport it should be a client, else a customer.

Any my script does not work, any ideas?

SET vSupport=('523','2203','1009','2185','2405','2186','1801','509','2202');

If(ActorEmployee_ID=$(vSupport),Client,'Customer') as "Type",

Re: If statment in load script with set value

m_woolf — Thu, 03 Mar 2016 17:18:47 GMT

if(index('$(vSupport)',ActorEmployee_ID)>0,'Client','Customer') as Type,

Re: If statment in load script with set value

Fri, 04 Mar 2016 06:49:57 GMT

Worked as a charm thanks