topic Re: using a variable within if in script module in QlikView

using a variable within if in script module

Tue, 11 Mar 2014 09:14:10 GMT

I have a requirement wherein I need to perform an if else transformation within the edit script on certain condition based on a variable

But when I apply the if condition on the variable to create the field it is giving me an error

For Eg:

The if condition used is

If($(varb)=’ORACLE’,

If(flag=1,-1,

If(flag=0,0)),flag) as FLAG

The error that I see is Oracle not found.

Can any one please let me know what could the issue

MK_QSL — Tue, 11 Mar 2014 09:15:21 GMT

Try

If('$(varb)'=’ORACLE’,

Tue, 11 Mar 2014 09:30:21 GMT

Hi Anu,

Try the below one.

If('$(varb)'='ORACLE',

If(flag=1,-1,

If(flag=0,0)),flag) as FLAG

Hope this helps!

Vinoth