topic Conditional Scripting in QlikView

Conditional Scripting

hkg_qlik — Thu, 09 Aug 2012 14:21:43 GMT

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,

Re: Conditional Scripting

giakoum — Thu, 09 Aug 2012 14:25:07 GMT

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

Re: Conditional Scripting

Anonymous — Thu, 09 Aug 2012 14:25:22 GMT

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