topic Re: Condition Help in QlikView

Condition Help

abhaysingh — Mon, 29 Feb 2016 14:51:49 GMT

if itemcode = 123 than CustomerNumber equal to FieldText else CustomerNumber

how to put it in if condition or any other optimized condition?

pls suggest

Re: Condition Help

sunny_talwar — Mon, 29 Feb 2016 14:53:44 GMT

Is this in the script? then may be this:

If(itemcode = 123, 'SomeText', CustomerNumber) as CustomerNumber

Re: Condition Help

abhaysingh — Tue, 01 Mar 2016 04:29:23 GMT

If(itemcode = 123, customer Number ='SomeText', CustomerNumber) as CustomerNumbe

i m luking someting like this, but its not working

Re: Condition Help

jonathandienst — Tue, 01 Mar 2016 05:01:01 GMT

>>If(itemcode = 123, customer Number ='SomeText', CustomerNumber) as CustomerNumber

That does not work because the syntax is invalid*. Sunny has answered your post with the correct solution. Also remember that field names are case sensitive in Qlikview/QlikSense, so CustomerNumber and customernumber are different fields.

*EDIT

Assuming the different forms of CustomerNumber are just typos, the syntax is not invalid, as CustomerNumber ='SomeText' will evaluate to true (-1) or false (0). But it is almost certainly semantically incorrect.