Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Thanks Ruben The syntax you had shared works inside the calculated field in Datamanager !
Thank you! This is an interesting issue and surprised that it still has not been resolved (as of 2024-05-13)