topic Re: Wildmatch and Multiple If Statements in QlikView

Wildmatch and Multiple If Statements

cbaqir — Thu, 14 Sep 2017 15:58:57 GMT

This works: if(wildmatch(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*' )>0, 'Provider', 'Non-Provider') as PROVIDER,

But this doesn't:

dual( if(wildmatch(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*' )>0, 'Provider'),
if(wildmatch(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*' )>0 and if(match(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*' )>0, 'Both'),
'Non-Provider')) as PROVIDER,

What is wrong with my syntax?

Re: Wildmatch and Multiple If Statements

antoniotiman — Thu, 14 Sep 2017 16:04:26 GMT

May be

dual( if(wildmatch(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*' )>0, 'Provider'),
if(wildmatch(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*' )>0 and match(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*' )>0, 'Both'),
'Non-Provider')) as PROVIDER,

Remove If( from If(match(GOV.....

Re: Wildmatch and Multiple If Statements

sunny_talwar — Thu, 14 Sep 2017 16:06:19 GMT

What is this doing?

dual( if(wildmatch(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*' )>0, 'Provider'),
if(wildmatch(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*' )>0 and if(match(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*' )>0, 'Both'),
'Non-Provider')) as PROVIDER,

Check for exact match? Then why use * in the check part?

Re: Wildmatch and Multiple If Statements

its_anandrjs — Thu, 14 Sep 2017 16:07:37 GMT

What if you use only this way why dual required here.

if(wildmatch(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*' ) > 0, 'Provider',

if(wildmatch(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*' ) > 0 and

if(match(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*') > 0,'Both'),'Non-Provider')) as PROVIDER,

Re: Wildmatch and Multiple If Statements

cbaqir — Thu, 14 Sep 2017 16:13:08 GMT

The GOV_DECISION_BODY field has multiple values. I need to have Provider = Both if there is a value = '*ECG*','*PCG*','*CCG*' and one that doesn't match.

Re: Wildmatch and Multiple If Statements

sunny_talwar — Thu, 14 Sep 2017 16:17:20 GMT

May be this

If(WildMatch(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*') > 0,

If(NOT WildMatch(GOV_DECISION_BODY, '*ECG*','*PCG*','*CCG*') > 0, 'Both', Provider'), 'Non-Provider') as PROVIDER

If this works, we can move to Dual part

Re: Wildmatch and Multiple If Statements

cbaqir — Thu, 14 Sep 2017 16:44:35 GMT

This doesn't seem to be working. I see provider and -.

Re: Wildmatch and Multiple If Statements

cbaqir — Thu, 14 Sep 2017 16:46:04 GMT

It's flagging an extra ")" somewhere.

Re: Wildmatch and Multiple If Statements

sunny_talwar — Thu, 14 Sep 2017 16:48:08 GMT

I guess they are contradicting statements.... this will not work... testing right now

Re: Wildmatch and Multiple If Statements

sunny_talwar — Thu, 14 Sep 2017 16:56:40 GMT

If your list within GOV_DECISION_BODY is separated by comma's (or similar character), you can try this

Table:

LOAD *,

If(WildMatch(GOV_DECISION_BODY, '*ECG*')+WildMatch(GOV_DECISION_BODY,'*CCG*')+WildMatch(GOV_DECISION_BODY, '*PCG*') = SubStringCount(GOV_DECISION_BODY, ',') + 1, 'Provider',

If(WildMatch(GOV_DECISION_BODY, '*ECG*')+WildMatch(GOV_DECISION_BODY,'*CCG*')+WildMatch(GOV_DECISION_BODY, '*PCG*') < SubStringCount(GOV_DECISION_BODY, ',') + 1 and

WildMatch(GOV_DECISION_BODY, '*ECG*')+WildMatch(GOV_DECISION_BODY,'*CCG*')+WildMatch(GOV_DECISION_BODY, '*PCG*') >= 1, 'Both', 'Non-Provider')) as PROVIDER;

LOAD * INLINE [

GOV_DECISION_BODY

"ECG, PCG"

"ECG, ABC"

"ABC, DEF"

];