topic Re: If Statement Where Field Begins With ... in QlikView

If Statement Where Field Begins With ...

Anonymous — Mon, 31 Aug 2015 14:18:31 GMT

I am trying to create an IF statement to classify different field values into normalized ranges. I want to make it so if FIELD starts with B it is categorized as 1 in NewField.

I have created the statement below but it is not working as desired. Any help would be appreciated.

If([FIELD] LIKE 'B%','1',

If([FIELD] LIKE 'Y%','2',

If([FIELD] LIKE 'P%','3',

If([FIELD] LIKE 'F%','4',)))) AS NewField

Thank you,

dave

Re: If Statement Where Field Begins With ...

sunny_talwar — Mon, 31 Aug 2015 14:21:32 GMT

Try this may be:

Pick(WildMatch(FIELD, 'B*', 'Y*', 'P*', 'F*'), 1, 2, 3, 4) as NewField

assuming you were using % for wild card

Re: If Statement Where Field Begins With ...

maxgro — Mon, 31 Aug 2015 14:22:09 GMT

pick(wildmatch(FIELD, 'B*', 'Y*', 'P*', 'F*', '*'), '1','2','3','4','other') as NewField

Re: If Statement Where Field Begins With ...

Anonymous — Mon, 31 Aug 2015 14:30:27 GMT

Thank you Massimo. Marked as helpful