If statement with And condition

[Anonymous]

I'm trying to create a Calculated field based on the Account number within some certain range of accounts.

The expression created as below, but show error. Please correct me if I used wrong expression.

If([LEDGERBALANCESDIM.ACCOUNTNUM]>='500000' and [LEDGERBALANCESDIM.ACCOUNTNUM]<='599999','COST OF SALES','OTHERS')

[mdmukramali]

HI Yusuf,

it seem expression looking fine.

can you share the sample app.

Thanks,

Mukram.

[Anonymous]

how can i share?

[mdmukramali]

Hi Yusuf,

Click on Reply ---> Use Advanced Editor  --> Attach

[Anonymous]

Sorry, I don't find Advanced Editor in my reply function, even though app having some confidentiality data which can make problem for me.

Expecting your understanding 

[mdmukramali]

I created a Dimension with similar condition which is working fine without any error .

[Anonymous]

Dear, I do the same except the = sign (not accepting in calculated field). as below

If([LEDGERBALANCESDIM.ACCOUNTNUM]>=400000 and [LEDGERBALANCESDIM.ACCOUNTNUM]<=499999,'True','False'), but still showing error, closing paranthesis with red error underline as indiacted.

[Anonymous]

Hi,

  It looks like the "AND" is not considered in your expression. Can you re check your function selection or try create a field in the script level.

-Jai

[Anonymous]

Yes, you are right, the same expression working in Script editor not working with create field level expression. even though while defining the expression in the expression box 'and' function is not showing. May be Qlik need to review the loaded function.

Thanks for your input and works well in Data Load editor.

[Anonymous]

Thanks all, working in Data Load Editor script not working in Field level expression.