I have several descriptive text fields in my data table. I would like for the ability to search for a string across all 5 fields and filter the data table accordingly if the string is in field1 OR field2 OR field3, etc. I know how to accomplish this via AND (by creating multiple actions) but not OR... My search string is coming from an input box and I have saved the variable value as vInputBox. I believe I need to use an action button, but I am having trouble connecting the dots. Here is what I tried (but I think this may only be applicable to qlikview:
Button -> select values matching search criteria -> '=field1= like ' & chr(39) & '*$(vInputBox)*' & chr(39) & ' or field2 like ' & chr(39) & '*$(vInputBox)*' & chr(39)
I REALLY need help on this so any pointing in the right direction is much appreciated