If statemet

[#1]

Hello,

I have a line chart and I am trying to put in an if statement.

In excel my formula is =if(J1<1,C1,C1/J1)

Is there a way to translate it into qlikview?

J is successfull attempts and C is attempts (if there are more failures than successful attempts J is represented by a negative number).

[jagannalla]

Hi,

You can use If statements in qlikview. You can use it in script level, dimension level and expression level.

for eg: If ( Failure > Successful, - Successful)

You can replace your fields instead of Failure and Successful

Thanks,

Jagan

[#3]

you can use If Statement in QV expressions:

and also have a look at "General Numeric Functions" in QV Help or if you can attach your sample.

for negative value, you have multiply it with "-1"