topic Re: If match AND Match AND NOT Match in QlikView

If match AND Match AND NOT Match

saiyashwan — Wed, 25 Nov 2020 16:16:04 GMT

I try to use this to create service column and but not all the values are getting populated ..and and not match condition value '0' getting displayed .. Any insight would really helps

if (match(Record_Type, ‘Authorized' AND Match(Sub_Type,'Appeal' )), 'Research' ,
if (match(Record_Type, 'PA'), ‘Determination' ,
if (match(Record_Type, ‘Information'), ‘Info',
if (match(Record_Type, 'Verification' ), 'Verification's',
if (match(Record_Type, ‘Authorization' AND NOT Match(Sub_Type,'Appeal' )), ‘Pre-Determination',
if (match(Record_Type, 'General’ AND Match(Sub_Type,'General Inquiry' )), ‘ Manager Inquiry',
if (match(Record_Type, 'Inquiry' AND Match(Sub_Type,'Detailed Inquiry' )), ‘Case Reviews',
if (match(Record_Type, 'Potential' ), Quality Report',
if (match(Record_Type, 'Commercial’), ‘ Assistance Program Enrollment',
if (match(Record_Type, ‘Step 1' AND Match(Sub_Type,'Coverage Follow Up' )), ‘Site of Care Follow up',
if (match(Record_Type, 'Copay' AND Match(Sub_Type,'New' ) ) ,'Pharmacy Activation' , '0'))))))))))) AS Service

Re: If match AND Match AND NOT Match

Vegar — Tue, 11 Jun 2019 04:22:13 GMT

It looks like you have a bunch of misplaced parentheses.

You code:
if (match(Record_Type, ‘Authorized' AND Match(Sub_Type,'Appeal' )), 'Resea....

Should probably look like this:
if (match(Record_Type, ‘Authorized' ) AND Match(Sub_Type,'Appeal' ), 'Resea...

Am I correct? If so then you have this syntax misspelling in multiple locations in your expression.

Re: If match AND Match AND NOT Match

Vegar — Tue, 11 Jun 2019 04:36:39 GMT

I also notice incorrect use of ‘ ’ where you should be using ' '.

Re: If match AND Match AND NOT Match

Haldeman14 — Tue, 11 Jun 2019 05:13:19 GMT

Well a simple error in use of single inverted comma...Just rectify it and your problem should be solved.I hope u r very much clear now

Re: If match AND Match AND NOT Match

jonathandienst — Tue, 11 Jun 2019 06:01:44 GMT

Like this:

if (match(Record_Type, 'Authorized') AND Match(Sub_Type, 'Appeal'), 'Research', if (match(Record_Type, 'PA'), 'Determination' , if (match(Record_Type, 'Information'), 'Info', if (match(Record_Type, 'Verification' ), 'Verification's', if (match(Record_Type, 'Authorization') AND NOT Match(Sub_Type, 'Appeal'), 'Pre-Determination', if (match(Record_Type, 'General') AND Match(Sub_Type, 'General Inquiry'), 'Manager Inquiry', if (match(Record_Type, 'Inquiry') AND Match(Sub_Type, 'Detailed Inquiry'), 'Case Reviews', if (match(Record_Type, 'Potential'), Quality Report', if (match(Record_Type, 'Commercial'), 'Assistance Program Enrollment', if (match(Record_Type, 'Step 1') AND Match(Sub_Type, 'Coverage Follow Up'), 'Site of Care Follow up', if (match(Record_Type, 'Copay') AND Match(Sub_Type, 'New'), 'Pharmacy Activation' , '0'))))))))))) AS Service

Re: If match AND Match AND NOT Match

saiyashwan — Tue, 11 Jun 2019 13:56:51 GMT

Thanks.. this solved the issue