Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

massimofavaro
New Contributor III

Help creating banal calculated column

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.

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Help creating banal calculated column

May be try with nested if

If(Sales >= 60,

     If(Sales < 90, 1, 0), 0) as Flag

3 Replies
MVP
MVP

Re: Help creating banal calculated column

May be try with nested if

If(Sales >= 60,

     If(Sales < 90, 1, 0), 0) as Flag

massimofavaro
New Contributor III

Re: Help creating banal calculated column

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.

MVP
MVP

Re: Help creating banal calculated column

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.