Solving the "wildcard dilemma": wildcard search for exact matches

    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():