Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Filter in script

Hi,

In my dataset, I have a large number of carriers, which I load in my script under the field name 'Carrier'. However, I am only interested in the data of two carriers, namely 'Malcolms' and 'Owens'. I know I can filter them out in my graphs with set analysis, but how can I already filter them out in my script?

1 Solution

Accepted Solutions
Highlighted
Champion
Champion

Hi Niek,

try using a WHERE clause:

LOAD

   ...

   ...

FROM ...

WHERE (carrier_name = 'Malcoms'

OR          carrier_name = 'Owens')

;

HTH

Best regards,

DataNibbler

View solution in original post

3 Replies
Highlighted
Champion
Champion

Hi Niek,

try using a WHERE clause:

LOAD

   ...

   ...

FROM ...

WHERE (carrier_name = 'Malcoms'

OR          carrier_name = 'Owens')

;

HTH

Best regards,

DataNibbler

View solution in original post

Highlighted
Not applicable

Yes, that worked. Thank you

Highlighted
Not applicable

You can Try with Match function as we like below:

LOAD *

FROM SOURCE.qvd (qvd)

WHERE MATCH(Carrier ,'Malcoms','Owens') ;