Question

Table Dimension - IF and contains

  • 16 April 2020
  • 2 replies
  • 6070 views

Hi everyone! I want to create a table dimnesion yes/no. Yes if the name contains “TOSTAO” and no otherwise. It sounds really easy but I haven’t found the answer.


IF (name =%TOSTAO%, yes, no)??


Thank you!


2 replies

Userlevel 3

Hello Silvana,


You’ll find a list of all the string functions here:



For your problem, there are different ways to achieve this but the easiest would be to simply use the contains() function. Remember that in functions when you refer to a field you need to use the use the ${view_name.field} format, which you get through autocomplete.


contains(${view_name.field},"TOSTAO")

Userlevel 7
Badge +1

If your IF is in SQL then you just make sure it returns boolean. Then the type: yesno will automatically convert boolean values to human-readable Yes and No

Reply