
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If match AND Match AND NOT Match
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Qlik Community MVP

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Qlik Community MVP

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
