topic Re: Help with Match function in if condition? in App Development

Help with Match function in if condition?

qlikuser222 — Fri, 09 Feb 2018 15:32:02 GMT

Hi Everyone,

Can you please help me to figure out what is wrong with below if condition?

Somehow its not giving expected results.

if(Type = 'XXX',if(Root <> 'Total', if(Match (Category,'8','1','2','33','35','3') and match(subtype,'20','21','23','20') ,

if([Date] >= IntialDate and [Date]<=FinalDate and [Amount] >= InitialAmt and [Amount] <= FinalAmt , [Amount] * YYY , if(Type = 'XXX',if(Root = 'Total' , if([Date] >= IntialDate and [Date]<=FinalDate and [Amount] >= InitialAmt and [Amount] <= FinalAmt, [Amount] * YYY)))))) as AAAA

Thanks

Re: Help with Match function in if condition?

_CD_ — Fri, 09 Feb 2018 16:18:36 GMT

Hello,

Perhaps because there's any final ")" for your multiple "if" ?

Re: Help with Match function in if condition?

Digvijay_Singh — Fri, 09 Feb 2018 16:37:12 GMT

Looks like few conditions are duplicated and doesn't make sense, as cdecluseau mentioned, one last ')' is missing.

Doesn't it look like this when remove duplicated condtions -

if(Type = 'XXX',

if(Root <> 'Total',

if(Match (Category,'8','1','2','33','35','3') and match(subtype,'20','21','23','20') ,

if([Date] >= IntialDate and [Date]<=FinalDate and [Amount] >= InitialAmt and [Amount] <= FinalAmt ,

[Amount] * YYY

)

) as AAAA

Re: Help with Match function in if condition?

swuehl — Fri, 09 Feb 2018 16:39:42 GMT

Yes, it's seems there is a closing parenthesis missing.

Besides this, it seems that your second condition based on Root = 'Total' can't evaluate to True, because it's in the THEN branch for your first condition Root <> 'Total':

if(Type = 'XXX',

if(Root <> 'Total',

if(Match (Category,'8','1','2','33','35','3') and match(subtype,'20','21','23','20'),

if([Date] >= IntialDate and [Date]<=FinalDate and [Amount] >= InitialAmt and [Amount] <= FinalAmt ,

[Amount] * YYY ,

if(Type = 'XXX',

if(Root = 'Total' ,

if([Date] >= IntialDate and [Date]<=FinalDate and [Amount] >= InitialAmt and [Amount] <= FinalAmt,

[Amount] * YYY

)

) /*missing Parenthesis added */ as AAAA

Re: Help with Match function in if condition?

qlikuser222 — Fri, 09 Feb 2018 17:28:33 GMT

Thanks for reply.

Unfortunately still not getting expected results. Any alternative to if condition there?

Thanks

Re: Help with Match function in if condition?

swuehl — Fri, 09 Feb 2018 17:37:40 GMT

Well, without knowing what you want to achieve (AKA 'expected results' in combination with input values), it's hard to help without guessing around.

Re: Help with Match function in if condition?

qlikuser222 — Fri, 09 Feb 2018 18:16:56 GMT

Hi,

Please find attached to the main question .It has example data in the script.

Thanks

Re: Help with Match function in if condition?

swuehl — Fri, 09 Feb 2018 20:23:57 GMT

Still not sure what you are trying to achieve.

Your Amt1 values does not match in the intervals given by InitialAmt and FinalAmt in your Calc table, that's why you don't get any Disc1 results.

Re: Help with Match function in if condition?

swuehl — Fri, 09 Feb 2018 20:34:47 GMT

Also take care to use an appropriate Date Format, so your date values show a numeric representation and you can use > or < for comparison.

I've changed some of your input Amt1 values to get the comparison with your limits working and guessed around what you might want to do.

Attached a sample that delivers something.