Conditional Scripting

[hkg_qlik]

Hi,

I want to categorize Members based on their employer name with a field name Record Owner:

For instance: If the employer name holds the value '1000' in its name  (eg. 1000 Benefit Funds) for those members, the record owner field should be 'A Type'

and if the employer name does not hold the value '1000' in its name (eg. Pension Funds) for those members, the record owner field should say 'B Type'

Regards,

H

[giakoum · Accepted solution]

if(index([employer name], '1000') > 0, 'A Type', 'B Type') as Type

[Anonymous]

use like or match function should accomplish ur requirement as below

if(employernamelike(1000),A)

you can learn about these function and video demo (with example )of more like the above req in qlikshare.com