topic Re: Error in Expression ')' expected in QlikView

Error in Expression ')' expected

Wed, 24 Jun 2015 12:57:56 GMT

Hi,

I have created multiple variables in my expression all without equals sign. When I use the variable individually they are generating fine. But when I use it in a if condition I get this error. THe condition is like

if(Cond1 = True OR Cond2 = True, $(vVar1), if(Cond3 = False, $(vVar2),0))

something like this. How do I tackle this error, not able to find anything related to this.

Kindly help, its a little urgent.

Thanks

Re: Error in Expression ')' expected

sunny_talwar — Wed, 24 Jun 2015 13:09:06 GMT

It would be more helpful if you post the actual expression, because this dummy expression doesn't seem to have any issue. May be we can find the issue in the original expression.

Best,

Sunny

Re: Error in Expression ')' expected

vvvvvvizard — Wed, 24 Jun 2015 13:12:03 GMT

Try

if(Cond1 = True OR Cond2 = True, $(=vVar1), if(Cond3 = False, $(=vVar2),0))

Re: Error in Expression ')' expected

Fri, 26 Jun 2015 00:29:22 GMT

Worked perfectly thanks.