Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
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.
Thanks to anyone who may help me.
May be try with nested if
If(Sales >= 60,
If(Sales < 90, 1, 0), 0) as Flag
May be try with nested if
If(Sales >= 60,
If(Sales < 90, 1, 0), 0) as Flag
Thanks, it works, but...seriously?
It's a real mess to use the "Add calculated field" feature.
My expression works in the data loader, why it does not in the calculated column field?
If I had to create a little more complicated expression it would be extremel inconvenient.
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.