Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If statemet

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).

2 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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"