Need to check if, say, ‘Apple’ is a part of string ‘AppleBees’. Any way I can do this?
Is there any function on QS which I can use to compare if a small text is part of a string? Or something on the lines of the LIKE function?
You can use the locate function : Locate - Amazon QuickSight
For dynamic search, you can create a parameter and pass it to the calculated field.
search word is : juice