Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Exclude data in script

I cannot figure out how to exclude names with 'coach' in them.

Demographic:

LOAD

     LEGAL_NAME,
     1 as Counter

FROM

Census.txt

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

WHERE LEGAL_NAME <> '*coach*';

Community Browser