Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
oscargm_bi
New Contributor II

Make a filter in the script after load a xsl file

Hi everyone,

 

I'm triying to make a filter in the Data Loader, for example

 

Column: SERVICE, this column bring me a lot name of services provides to a company, but I do not want that certainly services count in the app that I'm developing and the services are: AMBULANCE and PIMP.

 

How can I do the filter? any example?

 

Thanks a lot,

 

Regards,

 

Oscar,

Labels (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Make a filter in the script after load a xsl file

If you want to exclude AMBULANCE and PIMP, add a Where clause to the load:

...
Where Match(SERVICE, 'AMBULANCE', 'PIMP') = 0;

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
Partner
Partner

Re: Make a filter in the script after load a xsl file

You will have to use data load editor to filter the data
MVP
MVP

Re: Make a filter in the script after load a xsl file

If you want to exclude AMBULANCE and PIMP, add a Where clause to the load:

...
Where Match(SERVICE, 'AMBULANCE', 'PIMP') = 0;

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

MindaugasBacius
Valued Contributor III

Re: Make a filter in the script after load a xsl file

If you wish your data contains only services AMBULANCE and PIMP the load script should look like this:
Table_name:
Load *
From
Where Match(SERVICE, 'AMBULANCE', 'PIMP')
;