Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

 
3 Solutions

Accepted Solutions
Highlighted
Partner
Partner

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.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Partner
Partner

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

 
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted

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
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

5 Replies
Highlighted
Partner
Partner

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.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Partner
Partner

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

 
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Contributor
Contributor

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 

Highlighted

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
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Highlighted
Contributor
Contributor

Thanks.. this solved the issue