topic Re: Script not working in QlikView

Script not working

nareshthavidishetty — Wed, 13 Jan 2016 09:26:42 GMT

hi all,

i got a requirement there are some values as (a,b,c,d,e,f,g)

where a,b should be OK and rest as Non-Ok

need to create a field with values OK and Non-Ok

sunny_talwar — Wed, 13 Jan 2016 09:28:58 GMT

May be this:

If(Match(FieldName, 'a', 'b'), 'OK', 'Non-Ok) as NewFieldName

MK_QSL — Wed, 13 Jan 2016 09:29:35 GMT

If(Match(FieldName,'a','b'),'OK','Non-OK') as Flag

Anonymous — Wed, 13 Jan 2016 09:29:41 GMT

if (value='a') or (value='b'),'OK', 'Non-Ok' as newField

if (match(value,'a','b') > 0, 'OK', 'Non-Ok' as newField

PrashantSangle — Wed, 13 Jan 2016 09:29:54 GMT

Hi,

Create Flag in back end.

if(wildmatch(FieldName,'a','b'),'OK','Non - OK') as Flag;

Note: You can use match() or wildmatch() as per requirement.

Regards,

nareshthavidishetty — Wed, 13 Jan 2016 09:35:34 GMT

thanks sunny its working if i give wildmacth in the expression

PrashantSangle — Wed, 13 Jan 2016 09:37:17 GMT

Hi,

Wildmatch() is not case sensitive

where match() is case sensitive

For details search in Help menu.

REgards

sunny_talwar — Wed, 13 Jan 2016 09:38:45 GMT

I guess than use WildMatch if Fieldname can have 'a' and 'A' and both needs to be grouped as OK or you can do this:

If(Match(Lower(FieldName), 'a', 'b'), 'OK', 'Non-Ok) as NewFieldName

nareshthavidishetty — Wed, 13 Jan 2016 09:50:47 GMT

yes what u said is right i'm grouping a,A