Filtering Data Load

[#1]

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!

[vishsaggi]

Try Like:

LOAD col1,

          col2,

          Col3

FROM yourdatasource

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

[maxgro]

another one could be

load * inline [

Region

East

North

Sud

West

]

where

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

;

[#4]

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

[vishsaggi]

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;