As you know (???) QlikView ignores signs like ? or * for wildcard searches if there's an exact match...
Let's have a look at the following example:
LOAD '*5*' as Field AutoGenerate 1;
LOAD '5' as Field AutoGenerate 1;
LOAD '55555' as Field AutoGenerate 1;
If I search for "*5*" in a listbox or with the help of set analysis, I get only the exact match:
I found the solution accidentally :
--> just use expression search in combination with wildmatch():