Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtering Data Load

Hello,

I am a new user to Qlikview and I am trying to filter certain information out of a data load. As an example, I have 10 regions in my data (Northwest, Northeast, Midwest, etc.) and there are some regions that I do not want to be included in the Qlikview app at all. Is there an easy way to do a conditional/filtered load of the data. Any help is greatly appreciated. Thank you!

4 Replies
vishsaggi
Champion III
Champion III

Try Like:

LOAD col1,

          col2,

          Col3

FROM yourdatasource

WHERE Not Match(Region, 'Northwest','NorthEast','Midwest','East');

maxgro
MVP
MVP

another one could be

load * inline [

Region

East

North

Sud

West

]

where

  Region <> 'East' and Region <> 'West' and ......

;

Not applicable
Author

Thanks for the reply! I already have a Where statement associated with the load. How can I put in two where statements?

vishsaggi
Champion III
Champion III

May be like this: What is your other condition?

LOAD col1,

          col2,

          Col3

FROM yourdatasource

WHERE Not Match(Region, 'Northwest','NorthEast','Midwest','East') AND

             Yourother condition;