topic Re: Filter in script in QlikView

Filter in script

Thu, 09 Jan 2014 14:31:10 GMT

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?

Re: Filter in script

datanibbler — Thu, 09 Jan 2014 14:33:09 GMT

Hi Niek,

try using a WHERE clause:

LOAD

...

FROM ...

WHERE (carrier_name = 'Malcoms'

OR carrier_name = 'Owens')

;

HTH

Best regards,

DataNibbler

Re: Filter in script

Thu, 09 Jan 2014 14:39:31 GMT

Yes, that worked. Thank you

Re: Filter in script

Thu, 09 Jan 2014 14:54:10 GMT

You can Try with Match function as we like below:

LOAD *

FROM SOURCE.qvd (qvd)

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