Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
if itemcode = 123 than CustomerNumber equal to FieldText else CustomerNumber
how to put it in if condition or any other optimized condition?
pls suggest
Is this in the script? then may be this:
If(itemcode = 123, 'SomeText', CustomerNumber) as CustomerNumber
Is this in the script? then may be this:
If(itemcode = 123, 'SomeText', CustomerNumber) as CustomerNumber
If(itemcode = 123, customer Number ='SomeText', CustomerNumber) as CustomerNumbe
i m luking someting like this, but its not working
>>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.