QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Who Me Too'd this solution

swuehl
MVP
MVP

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

];

View solution in original post

Who Me Too'd this solution