topic match function in QlikView

match function

Tue, 15 Jul 2014 06:27:56 GMT

Hi guys

i have a scenario like below:

courseid={1,2,3,4,5,6,7,8,9,10}

If(Match(id,'1','2','3','4','5') ,'certified')

in the above condition it will return certi fied when ever all id's matches.. but i want result any one of the match case also

mean-> 1 or 2 0r 3 or 4 or 5 also i should get result "Certified"

please help me

Tue, 15 Jul 2014 08:07:40 GMT

PFA ...

Hope it satisfies your requirement

Vinayagam

ashfaq_haseeb — Tue, 15 Jul 2014 08:49:59 GMT

Hi,

try below

Load *,IF(Match(ID,1,2,3,4,5),'Certification','N/A') as CERTIFICATION;

LOAD * INLINE [

ID,

];

Regards

ASHFAQ

Anonymous — Fri, 07 Aug 2015 02:24:15 GMT

Hello,

Iam new to Qlickview and appreciate your help.

In the load script, i have the following nested If using Match function

If (match(LEGETYNACE7_BK,'6511001','6511002','7511001','7511006'), 'SOVEREIGNs-S7',

If(match(LEGETYNACE7_BK,'7511002','7511003','7511004','7511005','9112200'),'PSEs-S8',

If(match(LEGETYNACE7_BK,'6512101','6512102','6512103','6512104','9900301'),'FIN-INSTs-F1',

If(match(LEGETYNACE7_BK,'6512100','6512600','6512601','6512602','6512700','720302','6720303','7484702'),'OTHER-FIN-INSTs-F3',

If(match(CPT_LEID,'87431','322987','18820','60625698'),'SNEs-S6',

If(match(CPT_LEID,'18834','35534','18816','18849','82882'),'MDB-S3',

If(match(CPT_LEID,'11187','87667','10796','10879','10802','10867','603950'),'GSEs-F5'))))))) as Counterparty

It is displaying the first 4 .It is not displaying 'SNEs-S6', 'MDB-S3','GSEs-F5' under Counterparty.

Your help is highly appreciated.

Regards,

Paul