topic Re: Multiple IF statement Question. in QlikView

Multiple IF statement Question.

MuraliPrasath — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I've two fields, "CreditStatus" and "ProdOrder".

I need new field like "SortCodes" with with some if conditions.

CreditStatus --------------------------------> SortCodes

- (Null data) 0

B (With No "ProdOrder" data) give me 1

B (With "ProdOrder" data) give me 2

A&D ( With No "ProdOrder" data) give me 3

A&D ( With "ProdOrder" data) give me 4

I tried following but not worked. Need help!

if(match(CreditStatus,' '),'0',(if(match(CreditStatus,'B' and IsNull(ProdOrder)),'1',

(if(match(CreditStatus,'B' and (ProdOrder)),'2',

(if(match(CreditStatus,'A' or 'D' and IsNull(ProdOrder)),'3',

(if(match(CreditStatus,'A'or 'D' and (ProdOrder)),'4'))))))))) as Sortcodes

sunny_talwar — Mon, 25 Apr 2016 10:15:04 GMT

Try this:

If(Len(Trim(CreditStatus)) = 0, 0,

If(CreditStatus = 'B' and Len(Trim(ProdOrder)) = 0, 1,

If(CreditStatus = 'B' and Len(Trim(ProdOrder)) > 0, 2,

If(Match(CreditStatus,'A', 'D') and Len(Trim(ProdOrder)) = 0, 3,

If(Match(CreditStatus,'A', 'D') and Len(Trim(ProdOrder)) > 0, 4))))) as Sortcodes

MuraliPrasath — Mon, 25 Apr 2016 10:22:29 GMT

thanks Sunny:-)