Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Multiple if condition

Andrea B

Recommended Posts

You can create multiple IF conditions in Spotfire using the following syntax:

If([Column1] = value1, if([Column2] =value2, value3, value4), value5)Here if the column1 is equal to value1 the next if statement will be executed. So it will check if Column2 is equal to value2.

If Column2 is equal to value2, value3 would be returned or else value4 will be returned.

If Column1 is not equal to value1, it would return value5


Another way to do this is by using the Case statements:



When Your_Condition_A then value1


When Your_Condition_B then value2


Else value3



Hope that helps.

Link to comment
Share on other sites

  • Create New...