If statement error

[MikeJones]

Hi , when I enter the following if statement when trying to add a calculated field - 

If(TimeToAccept>29 and TimeToAccept<60,1) - 

Qlik informs me that I have an error - Missing right parenthesis.

TimetoAccept measures the difference in minutes from the time the order arrived and time we started working on it.

[JordyWegman]

Hi Mike,

Do you have some example data or a test app? The formula you have should work unless you have the -  really behind this.

If( TimeToAccept > 29 and TimeToAccept < 60
    , 1
)

Jordy

Climber

[MikeJones]

Hi Jordy, below is a sub set of the data I'm using.

Jobid	TimeToAccept
1	49
2	41
3	1038
4	1016
5	1305
6	69
7	845
8	NULL
9	706
10	14
11	NULL
12	11
13	12
14	23
15	NULL
16	18
17	9

[JordyWegman]

Hey Mike,

I copied my solution and this seems to work:

Check the app in the attachment.

Jordy

Climber

[MikeJones]

Hi Jordy, thanks for your help.  I can't download the qvf file.

[Or · Accepted solution]

If this is in Data Manager, you will need to avoid using AND since it is not supported. Use a nested if() instead, or switch to Data Load Editor.