Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
hkg_qlik
Contributor II

Conditional Scripting

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

1 Solution

Accepted Solutions
giakoum
Honored Contributor II

Re: Conditional Scripting

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

2 Replies
giakoum
Honored Contributor II

Re: Conditional Scripting

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

srikanthsri1
Valued Contributor

Re: Conditional Scripting

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

Community Browser