Multiple if condition

[Andrea B]

Hwo do I create multiple if conditions in Spotfire

[Karan Nisar]

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.