topic Multiple If statement using match help needed in QlikView

Multiple If statement using match help needed

Mon, 26 Jan 2015 19:47:19 GMT

if (not(Match([Workout Type],'Collections Repay','Conditional DIL','Conditional 'Repayment Plan (FHA)',
'ShortSale','VA Mod w/o Trial')and
(Match([Template Name],'HMP','ALT2011','APOLLO','MOD24')and
(Match([Workout Status],'WORKOUT APPROVED','TRIAL ON STREET','IN TRIAL','VERBAL ACCEPT RECVD'),1,0)))) as [TM Include Flag],

What I am trying to say here is that

a. if the Workout Type is not one of 'Collections Repay','Conditional DIL','Conditional 'Repayment Plan (FHA)','ShortSale','VA Mod w/o Trial' and

b. If the template name is one of 'HMP','ALT2011','APOLLO','MOD24' and

c. If workout status is one of 'WORKOUT APPROVED','TRIAL ON STREET','IN TRIAL','VERBAL ACCEPT RECVD' assign a 1 for yes else assign a 0 for no

I cannot seem to get this code to work. Anything wrong with the enclosing brackets here?

Re: Multiple If statement using match help needed

maxgro — Mon, 26 Jan 2015 19:56:15 GMT

if (not Match([Workout Type],'Collections Repay','Conditional DIL','Conditional Repayment Plan (FHA)', 'ShortSale','VA Mod w/o Trial')

and Match([Template Name],'HMP','ALT2011','APOLLO','MOD24')

and Match([Workout Status],'WORKOUT APPROVED','TRIAL ON STREET','IN TRIAL','VERBAL ACCEPT RECVD'),1,0) as [TM Include Flag]

Re: Multiple If statement using match help needed

Anonymous — Mon, 26 Jan 2015 19:59:29 GMT

Looks like there are three unnecessary closing parenthesis at the end.

Besides, something is not right with the single quote between Conditional and Repayment. It looks out of place.

Re: Multiple If statement using match help needed

MarcoWedel — Tue, 27 Jan 2015 00:01:02 GMT

-(not Match([Workout Type],'Collections Repay','Conditional DIL','Conditional Repayment Plan (FHA)','ShortSale','VA Mod w/o Trial')
  and Match([Template Name],'HMP','ALT2011','APOLLO','MOD24')
  and Match([Workout Status],'WORKOUT APPROVED','TRIAL ON STREET','IN TRIAL','VERBAL ACCEPT RECVD')) as [TM Include Flag]

hope this helps

regards

Marco

Re: Multiple If statement using match help needed

jagan — Tue, 27 Jan 2015 03:00:32 GMT

HI,

Try this statement

if (Not Match([Workout Type],'Collections Repay','Conditional DIL','Conditional 'Repayment Plan (FHA)', 'ShortSale','VA Mod w/o Trial') and
Match([Template Name],'HMP','ALT2011','APOLLO','MOD24')and
Match([Workout Status],'WORKOUT APPROVED','TRIAL ON STREET','IN TRIAL','VERBAL ACCEPT RECVD'), 1,0) as [TM Include Flag],

Regards,

Jagan.