I am trying to create a very easy calculated column in the Data Editor.
I have a numeric column [Sales] and I'd like a calculated column that's equal to 1 if Sales is <90 and >= 60, and 0 otherwise.
Shouldn't it be "IF([Sales] < 90 AND [Sales] >= 60, 1, 0)"?
It keeps saying something like"No preview. Use a valid expression." and I don't undertand why.
The box where I have to write the code of the calculated column is, moreover, very buggy: sometimes when I press space it moves to the end of the expression and it's very hard to write a complex formula.
I have not used this new feature of Qlik Sense... but I have heard that adding ADD condition (have not heard about or, but may be OR condition) makes it throw error. I am not sure what the timeline is to get this fixed, but I think that Qlik already knows about the issue. May be mto might be able to give an idea on this.