topic Comparing variable value in IF condition in QlikView

Comparing variable value in IF condition

Thu, 31 Jan 2013 09:45:13 GMT

Hello,

Can any one let me know how to compare a variable value inside IF statement?

For eg: If $(vPlant) = 'HCM123' then

.....

....

else

....

EndIF.

Is this syntax correct? If yes,It is not working for me.Could you pls suggest me an another alternative.

I have also tried the same with Match function but still not able to execute the stmts inside if.

Thanks.

alexandros17 — Thu, 31 Jan 2013 09:49:28 GMT

If you have declared the variable with LET try

If vPlant = 'HCM123' then ...

so the variable without $ and ()

Thu, 31 Jan 2013 11:06:53 GMT

Thank you Alex,it worked for me...