Executing the advanced search with more than one wildcard
From a table with over 4000 entries, I would have to find those that contain either the string *name1* OR the string *name2* OR 'name3'. The table has the following values: Value1: Name1/Name2 Value2: Name3/Name4 Value3: Name1/Name3 Value4: Name4/Name2 Value5: Name3/Name3 All combinations are possible, whereby each name can be at the beginning or end of the string. Name1 Name2 finds value1 because the value starts with Name1. Name2 does not find a result. I would actually have to search for *Name1* *Name3* *Name4*. Unfortunately, this does not work with the wildcards. How can I combine several searches with wildcards like a OR combination?
By creating new dimensions/flags it was meant within Qlik and not in the source-system. If you couldn't access Qlik on the script-level you should transfer this task to the responsible team. All essential logic belonged to the data-model and shouldn't not created with a hard-coding within the UI - especially not within calculated dimensions.
Beside this should an exclusion also be working with a wildmatch but like mentioned this is logically tricky. Before struggling further with the combination - split each part of it within a single expression side by side - just returning TRUE or FALSE. Could you really get for all a TRUE on the appropriate dimension value? If yes, the previous conditions wasn't correct respectively correctly linked and otherwise the existing data-set doesn't support the wanted view.
