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.
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 )
Hi Jordy, below is a sub set of the data I'm using.