topic Re: Match function with 2 or more options in QlikView

Match function with 2 or more options

helen_pip — Wed, 10 Apr 2013 14:22:58 GMT

Hello

Could someone kindly help me write match statement, because my attempt below is not working

(Match(CCG_TREND, '2M','3R', '1K', '1J', '9M', '1V'), 'Hampshire') ,If(Match(CCG_TREND, '10X'), 'Southampton') as Test

I also want to incoporate another option which will be "Other"

Can anyone kindly help me write this

Thanks

Helen

Wed, 10 Apr 2013 16:18:11 GMT

Try this

if(Match(CCG_TREND, '2M','3R', '1K', '1J', '9M', '1V') > 0, 'Hampshire',

if(Match(CCG_TREND, '10x') > 0,'Southampton',

'Other'))

You dont need the second Match if you are only testing for 1 value, you could just have a simple If so somthing like this

if(Match(CCG_TREND, '2M','3R', '1K', '1J', '9M', '1V') > 0, 'Hampshire',

if(CCG_TREND = '10x', 'Southampton','Other'))