Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if(index([employer name], '1000') > 0, 'A Type', 'B Type') as Type
if(index([employer name], '1000') > 0, 'A Type', 'B Type') as Type
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