topic Re: Expression not working in QlikView

Expression not working

Tue, 03 Dec 2013 22:57:28 GMT

if([NCR_TYPE]='RI','Receiving Inspection',[NCR_TYPE]) and if([NCR_TYPE]='IP','In-Process',[NCR_TYPE]) as [Flag],

Re: Expression not working

swuehl — Tue, 03 Dec 2013 23:24:24 GMT

What do you get returned? -1 for all records?

And what do you expect as result for different input values?

'Expression not working' is not really helpful to understand your requirement.

Re: Expression not working

Tue, 03 Dec 2013 23:33:00 GMT

Trying to chage the feild value..

I could get using Wildmatch

(wildmatch(NCR_TYPE,'RI'),'Receiving Inspection',

if(wildmatch(NCR_TYPE,'IP'),'In-Process',

if(wildmatch(NCR_TYPE,'',' ') or isnull(NCR_TYPE),'NULL'))),

Re: Expression not working

swuehl — Tue, 03 Dec 2013 23:45:21 GMT

If you don't use wildcards, you don't need the wildmatch() function. And instead of multiple if() statements, you can use a pick() / match() combination:

pick( match(NCR_TYPE,'RI','IP')+1 //+1 to return 1 for no matching value

,'NULL'

,'Receiving Inspection'

,'In-Process'

)

as [Flag]

Re: Expression not working

Tue, 03 Dec 2013 23:54:03 GMT

It worked .Thank you.