Datamanager - Calculated field - IF AND Condition

[privatevinodh]

Am new to qliksense. Using Datamanager Table edit am trying to add a new calc field. In that field am trying to write an expression with IF condition like

IF(Income>8000 and Income<=30000,1,0) 

Getting an error missing right parenthesis. Can we use IF with And inside calculated field in Data manager ?

Kindly help

[rubenmarin · Accepted solution]

Hi, this looks like a bug in data manager, this syntax would work if you use the script editor instead of data manager.

As a workoarund you can use a syntax like: If(Income>8000, If(Income<=30000,1,0), 0)

[privatevinodh]

Thanks Ruben The syntax you had shared works inside the calculated field in Datamanager !

[NKOPS1982]

Thank you!  This is an interesting issue and surprised that it still has not been resolved (as of 2024-05-13)