topic Re: If statement in QlikView

If statement

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

I am working on an if statement in qlikview to find method of payment based on check number, but i keep getting a syntax error.

Can anyone assist please I am not sure what I am doing wrong.

(left([Check Number],1,)

1, 'Check',

7, 'Card',

8, 'ACH',

9, 'Wire',

'Other')

Thank you in advance for any assitance

Re: If statement

jwjackso — Wed, 28 Mar 2018 21:35:19 GMT

=If(Left([Check Number],1) = 1,'Check',

If(Left([Check Number],1) = 7,'Card',

If(Left([Check Number],1) = 8,'ACH',

If(Left([Check Number],1) = 9,'Wire','Other'))))

Re: If statement

Anonymous — Wed, 28 Mar 2018 21:38:01 GMT

Thank you, it worked

Re: If statement

MarcoWedel — Wed, 28 Mar 2018 22:10:01 GMT

another option:

Pick(WildMatch([Check Number],'1*','7*','8*','9*','*'),'Check','Card','ACH', 'Wire','Other')

hope this helps

regards

Marco

Re: If statement

MarcoWedel — Wed, 28 Mar 2018 22:10:48 GMT

please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

Re: If statement

sasiparupudi1 — Thu, 29 Mar 2018 07:49:44 GMT

Please close this thread by marking a correct answer

Re: If statement

Anonymous — Thu, 29 Mar 2018 09:27:45 GMT

Hi Use below code.

If(Left([Check Number],1) = 1,'Check',

If(Left([Check Number],1) = 7,'Card',

If(Left([Check Number],1) = 8,'ACH',

If(Left([Check Number],1) = 9,'Wire','Other'))))

Thanks,

Venkata Sreekanth

Re: If statement

Peter_Cammaert — Thu, 29 Mar 2018 09:37:39 GMT

Keep in mind that there are two uses of the IF keyword. There is an IF() function that is to be used in expressions and there is an IF control statement that can be used on the outer statement level and in statement blocks but not inside other statements like LOAD.

The IF() function that you seem to be using must be treated as a regular function that accepts parameters and returns a true/false value. IF() function calls can also be nested like regular function calls, as shown in the many examples in this thread.

Re: If statement

Anonymous — Sun, 01 Apr 2018 16:58:55 GMT

HI Marco, how do I close it?

Re: If statement

sunny_talwar — Sun, 01 Apr 2018 17:01:16 GMT

Check here to see how to mark correct responses....

Qlik Community Tip: Marking Replies as Correct or Helpful