Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm trying to load my data in and have used in the script a 'where not' to exclude two credit numbers - See the photo, however this is not working and when I go to create my visualisations, the two credit numbers are included in the data.
What am I doing wrong here? The same is happening with the Svc branch number.
Perhaps these ways
Where not ("Credit Number" like '201915523' or "Credit Number" like '201915522') or
Not ("Svc Branch Number" like '91' or "Svc Branch Number" like '92' or ....)
Where not Match("Credit Number", '201915523', '201915522') or
Not Match("Svc Branch Number", '91', '92',..)