topic Re: If statement with And condition in QlikView

If statement with And condition

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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')

Re: If statement with And condition

mdmukramali — Sun, 19 Nov 2017 11:37:31 GMT

HI Yusuf,

it seem expression looking fine.

can you share the sample app.

Thanks,

Mukram.

Re: If statement with And condition

Anonymous — Sun, 19 Nov 2017 12:15:52 GMT

how can i share?

Re: If statement with And condition

mdmukramali — Sun, 19 Nov 2017 12:31:19 GMT

Hi Yusuf,

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

Re: If statement with And condition

Anonymous — Sun, 19 Nov 2017 13:14:50 GMT

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

Re: If statement with And condition

mdmukramali — Sun, 19 Nov 2017 13:22:35 GMT

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

Re: If statement with And condition

Anonymous — Mon, 20 Nov 2017 10:17:05 GMT

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.

Re: If statement with And condition

Anonymous — Mon, 20 Nov 2017 10:46:12 GMT

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

Re: If statement with And condition

Anonymous — Mon, 20 Nov 2017 11:56:37 GMT

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.

Re: If statement with And condition

Anonymous — Mon, 20 Nov 2017 12:09:01 GMT

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