topic Re: Match function in QlikView

Match function

Mon, 14 Jul 2014 13:43:12 GMT

Hi Guys,

Please Help me in below IF condition when ever all listed curriculum_title matches its returned as 'certified' ( and condition)

but i want 'or' condition any one of the curriculum_title matches and status matched then also i should get result as 'certified'

if(Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',

'Corporates Analyst and Associate Director',

'Covered Bonds Analyst and Associate Director',

'International Public Finance Analyst and Associate Director',

'Sovereigns Analyst and Associate Director',

'Structured Finance Analyst and Associate Director',

'Insurance Analyst and Associate Director',

'Fund and Asset Management Analyst and Associate Director',

'US Public Finance Analyst and Associate Director',

'Global Infrastructure Group Analyst and Associate Director') and CURRICULUM_STATUS= 'ACQUIRED','Certified')

please help me. how can i get same result if any thing matches in the list

Thanks

Damodhar

Re: Match function

its_anandrjs — Mon, 14 Jul 2014 13:50:07 GMT

I believe your expression worked as OR condition also or you can try with

if(Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',

'Corporates Analyst and Associate Director',

'Covered Bonds Analyst and Associate Director',

'International Public Finance Analyst and Associate Director',

'Sovereigns Analyst and Associate Director',

'Structured Finance Analyst and Associate Director',

'Insurance Analyst and Associate Director',

'Fund and Asset Management Analyst and Associate Director',

'US Public Finance Analyst and Associate Director',

'Global Infrastructure Group Analyst and Associate Director') OR CURRICULUM_STATUS= 'ACQUIRED','Certified')

Re: Match function

Anonymous — Mon, 14 Jul 2014 13:54:38 GMT

Match() returns an integer of the matching string, so you need to check it is > 0, as per below.

if( ( Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',

'Corporates Analyst and Associate Director',

'Covered Bonds Analyst and Associate Director',

'International Public Finance Analyst and Associate Director',

'Sovereigns Analyst and Associate Director',

'Structured Finance Analyst and Associate Director',

'Insurance Analyst and Associate Director',

'Fund and Asset Management Analyst and Associate Director',

'US Public Finance Analyst and Associate Director',

'Global Infrastructure Group Analyst and Associate Director') > 0 ) and CURRICULUM_STATUS= 'ACQUIRED','Certified')

Re: Match function

PradeepReddy — Mon, 14 Jul 2014 13:59:10 GMT

if(Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',

'Corporates Analyst and Associate Director',

'Covered Bonds Analyst and Associate Director',

'International Public Finance Analyst and Associate Director',

'Sovereigns Analyst and Associate Director',

'Structured Finance Analyst and Associate Director',

'Insurance Analyst and Associate Director',

'Fund and Asset Management Analyst and Associate Director',

'US Public Finance Analyst and Associate Director',

'Global Infrastructure Group Analyst and Associate Director') and (CURRICULUM_STATUS= 'ACQUIRED' OR CURRICULUM_STATUS='Certified')

Re: Match function

alexandros17 — Mon, 14 Jul 2014 14:01:46 GMT

Try to use wildmatch instead of Match, do you use the formula in a expression?

Re: Match function

its_anandrjs — Mon, 14 Jul 2014 14:04:37 GMT

Another one you try with

if( ( Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',

'Corporates Analyst and Associate Director',

'Covered Bonds Analyst and Associate Director',

'International Public Finance Analyst and Associate Director',

'Sovereigns Analyst and Associate Director',

'Structured Finance Analyst and Associate Director',

'Insurance Analyst and Associate Director',

'Fund and Asset Management Analyst and Associate Director',

'US Public Finance Analyst and Associate Director',

'Global Infrastructure Group Analyst and Associate Director') OR CURRICULUM_STATUS='ACQUIRED') ,'Certified')