Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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 |
Hey Mike,
I copied my solution and this seems to work:
Check the app in the attachment.
Jordy
Climber
Hi Jordy, thanks for your help. I can't download the qvf file.
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.