topic Match Clause in QlikView

Match Clause

Fri, 23 Oct 2015 11:29:59 GMT

Hi,

I am struggling with a match clause and am not sure of another way to get the result I am looking for.

When I do this, I get the result I am looking for:

=If (MATCH ([C_Code],'KAT 001','AACC 000','ZAM001','PLO 001'),'P CUSTOMERS')

But when I alter it to use numbers, then it doesnt work:
=If (MATCH ([S_App Number],'408600000','20000000','40500000',),'P CUSTOMERS')

Do you perhaps know what I am doing wrong?

Thanks

Yolanda

Re: Match Clause

srchilukoori — Fri, 23 Oct 2015 18:22:27 GMT

Hi,

please post a sample data. My guess is the number format in the [S_App Number] is changed while loading in to the app.

Thanks.

Re: Match Clause

Fri, 23 Oct 2015 18:33:07 GMT

Hi Yolanda,

Looks like you have an extra comma:

=If (MATCH ([S_App Number],'408600000','20000000','40500000',),'P CUSTOMERS')

CORRECTED:

=If (MATCH ([S_App Number],'408600000','20000000','40500000'),'P CUSTOMERS')

Re: Match Clause

prabhu0505 — Fri, 23 Oct 2015 18:42:47 GMT

That means:

MATCH ([C_Code],'KAT 001','AACC 000','ZAM001','PLO 001') - has match (Match functions returns positive value).

MATCH ([S_App Number],'408600000','20000000','40500000',) - does not have a match (Match functions returns zero). Moreover I could see one extra comma before parenthesis '40500000',) pls take care.

Re: Match Clause

Qrishna — Fri, 23 Oct 2015 19:03:48 GMT

Try

=If (MATCH ([S_App Number],'408600000','20000000','40500000'),'P CUSTOMERS') //extra comma as prabhu stated

=If (MATCH ([S_App Number],'408600000','20000000','40500000') =1,'P CUSTOMERS')

//sometimes Match() condition in if() statement needs to be checked to return the output for the condition.

//match(') = 1 true ,match(') = 0 false - something like this