Multiple IF Statements

[#1]

How do we write Multiple IF Statements in Qliksense. I tried this way.

if((fabs($(Difference)))/($(Approved Limit Dec 13)) > 0.5,black())

if((fabs($(Difference)))/($(Approved Limit Dec 13)) > 0.9,red())

When I give only the first If statement, it works. On Line 2, when I introduce the second IF statement, the function does not work. Is there any issue with the syntax?

[marcus_sommer · Accepted solution]

Try this:

if(fabs($(Difference))/$(Approved Limit Dec 13) > 0.5,black(),

if(fabs($(Difference))/$(Approved Limit Dec 13) > 0.9,red()))

- Marcus

[#3]

Thank You. It worked.

[jagan]

Hi,

I think

if(fabs($(Difference))/$(Approved Limit Dec 13) > 0.9, Red(),

if(fabs($(Difference))/$(Approved Limit Dec 13) > 0.5,Black()))

Otherwise you will get all Black() colors. 0.9 is greater than 0.5, so It never comes to Else.

Hope this helps you.

Regards,

Jagan.