Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jim_chan
Not applicable

How to use WHERE in load statement?

Hi guys,

I want to filter this table with another condition ,  only show me  data from company_id which is 1,2,3,4,5. how should i put it in my where statement, as below:

table1:

load*

FROM

[..\QVD\BASE\FACT_table1_*.qvd] (qvd)

where (name <> 'Nick' and country <> 'Thailand' and company_id = '1,2,3,4,5');

It didnt work.

Rgds,

Jim

1 Solution

Accepted Solutions
johnw
Not applicable

Re: How to use WHERE in load statement?

Do you have a single company with ID 1,2,3,4,5, or are those different IDs for five different companies? If the latter:

where name <> 'Nick'

and country <> 'Thailand'

and match(company_id,'1','2','3','4','5');

1 Reply
johnw
Not applicable

Re: How to use WHERE in load statement?

Do you have a single company with ID 1,2,3,4,5, or are those different IDs for five different companies? If the latter:

where name <> 'Nick'

and country <> 'Thailand'

and match(company_id,'1','2','3','4','5');