topic excluding some data from load in QlikView

excluding some data from load

rcorcoran — Mon, 02 Oct 2017 14:35:16 GMT

I have a dashboard that is loading data from a database. The script below works fine to load service provider data and also to create a composite key. However I need to change it now to exclude where the SPType is A1, A2 and A3. Could anyone tell me where/how I should do this?

Any help appreciated

Load
AUTONUMBER(SGType & SGKey & '_' & SPType & SPKey & '_' & 'CHO' & RDOKey, 'FC') as FullComposite,
SGType & SGKey & '_' & SPType & SPKey & '_' & 'CHO' & RDOKey as [SP Table FullComposite Code],
RDOKey as LookupRDO,
SGKey as LookupSGNum,
SGType as LookupSGType,
SGType & SGKey as SGComposite,
SPKey as LookupSPNum,
SPType as LookupSPType,
SPType & SPKey as SPComposite;
// SGType & SGKey & '_' & SPType & SPKey & '_' & 'CHO' & RDOKey as FullComposite;

SQL SELECT
RDOKey,
SGKey,
SGType,
SPKey,
SPType
FROM Healthstat_2015.dbo.ServiceProvider;

Re: excluding some data from load

sunny_talwar — Mon, 02 Oct 2017 14:37:57 GMT

May be this

Load
AUTONUMBER(SGType & SGKey & '_' & SPType & SPKey & '_' & 'CHO' & RDOKey, 'FC') as FullComposite,
SGType & SGKey & '_' & SPType & SPKey & '_' & 'CHO' & RDOKey as [SP Table FullComposite Code],
RDOKey as LookupRDO,
SGKey as LookupSGNum,
SGType as LookupSGType,
SGType & SGKey as SGComposite,
SPKey as LookupSPNum,
SPType as LookupSPType,
SPType & SPKey as SPComposite;
// SGType & SGKey & '_' & SPType & SPKey & '_' & 'CHO' & RDOKey as FullComposite;

SQL SELECT
RDOKey,
SGKey,
SGType,
SPKey,
SPType
FROM Healthstat_2015.dbo.ServiceProvider

WHERE SPType not in ('A1', 'A2', 'A3');

Re: excluding some data from load

rcorcoran — Mon, 02 Oct 2017 14:53:20 GMT

Thanks so much Sunny worked a treat