Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
If you have some few exclusions, define your exclusions in a string variable and then use the variable in wildmatch:
Set vExclude = '*iti*' , '*ito*';
LOAD *,
If(Name Like '*IT*' and Wildmatch(Name, $(vExclude)) = 0, 1,0 ) as ITExceptions;
LOAD * INLINE [
Name
IT
ITiti
ITito
];