topic If statemet in QlikView

If statemet

Tue, 21 Jan 2014 14:15:43 GMT

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 — Tue, 21 Jan 2014 14:26:40 GMT

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

Tue, 21 Jan 2014 14:36:54 GMT

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"