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:

Case

 

When Your_Condition_A then value1

 

When Your_Condition_B then value2

 

Else value3

 

End

Hope that helps.

Link to comment
Share on other sites

×
×
  • Create New...