Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

madeleine_josef
New Contributor III

Excluding data

Hello,

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')

7 Replies

Re: Excluding data

Looks good to me. Is it not working? Alternatively you can also try this:

Where BookingCompany <> 'CompanyX';

Re: Excluding data

Yes, that looks correct.


talk is cheap, supply exceeds demand
madeleine_josef
New Contributor III

Re: Excluding data

No it is not giving me the correct result, can it be that I have made so many selections in my dataset?

LOAD [BookingDate],

[SalesPerson],

[AlfaCompany],

[AssignmentNumber],

[AssignmentType],

[BookingCompany],

[OpenOrClosed],

[Assignee],

[OriginCity],

[OriginCountryCode],

[DestinationCity],

[DestinationCountryCode],

[LoadingDate],

[UnloadingDate],

[Volume],

[NetWeight],

[InsuranceValue],

[InsuranceValueProc],

[Household],

[InsuranceCurrency],

[MoveManager],

[StandardInsured],

[TransportInsurenace],

[SetAndParInsurnace],

[ElectronicInsurance],

[SetAndParInsurnaceProc],

[ElectronicInsuranceProc],

[PerformanceDate]

FROM

(qvd)where match([StandardInsured],'1') or match([Household],'1') or match ([TransportInsurenace],'1') or (([InsuranceValue])>'1')

and ([BookingCompany]<>'32038')

Should I write the last portion concerning booking company separate in some way?

MVP
MVP

Re: Excluding data

YOu can also simply write

Where [BookingCompany] <> 'CompanyX';


For case insensitive

Where Not  Mixmatch([BookingCompany], 'CompanyX');


Hope this helps you.


Regards,

Jagan.


Not applicable

Re: Excluding data

your brackets look to have gone astray.

where (match([StandardInsured],'1') or match([Household],'1') or match ([TransportInsurenace],'1') or [InsuranceValue]>'1')

and [BookingCompany]<>'32038'

this will return records where BookingCompany is not '32038' AND one (or more) of the other requirements are met.

MVP
MVP

Re: Excluding data

Hi,

Try this

FROM

(qvd)

where ([StandardInsured]= 1 or [Household]=1 OR [TransportInsurenace]= 1  or[InsuranceValue] >'1')

and [BookingCompany]<>'32038'

reddys310
Honored Contributor II

Re: Excluding data

Hi Madeleine,

You even make use of "where not exists()"

Thanks,

Sangram.

Community Browser