Discussion board where members can get started with Qlik Sense.
I would like to exclude data in my data load editor script, how can I write this?
would like to have all data exept the data connected to companyX.
Can I write like this?
Where not match([BookingCompany],'CompanyX')
Looks good to me. Is it not working? Alternatively you can also try this:
Where BookingCompany <> 'CompanyX';
Yes, that looks correct.
No it is not giving me the correct result, can it be that I have made so many selections in my dataset?
(qvd)where match([StandardInsured],'1') or match([Household],'1') or match ([TransportInsurenace],'1') or (([InsuranceValue])>'1')
Should I write the last portion concerning booking company separate in some way?
YOu can also simply write
Where [BookingCompany] <> 'CompanyX';
For case insensitive
Where Not Mixmatch([BookingCompany], 'CompanyX');
Hope this helps you.
your brackets look to have gone astray.
where (match([StandardInsured],'1') or match([Household],'1') or match ([TransportInsurenace],'1') or [InsuranceValue]>'1')
this will return records where BookingCompany is not '32038' AND one (or more) of the other requirements are met.
where ([StandardInsured]= 1 or [Household]=1 OR [TransportInsurenace]= 1 or[InsuranceValue] >'1')
You even make use of "where not exists()"