topic Re: Match(If statement with 3 elements in QlikView

Match(If statement with 3 elements

helen_pip — Wed, 06 Mar 2013 11:54:11 GMT

Hello

I have written a match(if statement but it does not seem to be wokring correctly, although no errors turn up in the reload , although i do not get the desired results

If(Match(month_end_breach_risk_6wks, '3) Dated - in month breach', '4) Dated - month end breach'), 'Other', Match(month_end_breach_risk_6wks,'2) No date','No Date', 'Date In Time')) as Test

Could someone cast an eye over my If statement , what I want to achieve is 3 elements

1) Other

2) No Date

3) Dated In Time

Thanks

Helen

Re: Match(If statement with 3 elements

kaushiknsolanki — Wed, 06 Mar 2013 12:02:02 GMT

Try this,

If(wildmatch(month_end_breach_risk_6wks, '3) Dated - in month breach', '4) Dated - month end breach'), 'Other',

if(wildmatch(month_end_breach_risk_6wks,'2) No date'),'No Date', 'Date In Time')) as Test

Regards,

Kaushik Solanki

Re: Match(If statement with 3 elements

helen_pip — Wed, 06 Mar 2013 12:37:26 GMT

Thank you

This works a treat

Thanks

Helen