Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
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
Esteemed Contributor III

Re: Filtering Data Load

Try Like:

LOAD col1,

          col2,

          Col3

FROM yourdatasource

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

MVP
MVP

Re: Filtering Data Load

another one could be

load * inline [

Region

East

North

Sud

West

]

where

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

;

Not applicable

Re: Filtering Data Load

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

vishsaggi
Esteemed Contributor III

Re: Filtering Data Load

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;