topic Filtering Data Load in QlikView

Filtering Data Load

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Filtering Data Load

vishsaggi — Fri, 17 Mar 2017 19:36:58 GMT

Try Like:

LOAD col1,

col2,

Col3

FROM yourdatasource

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

Re: Filtering Data Load

maxgro — Fri, 17 Mar 2017 19:40:34 GMT

another one could be

load * inline [

Region

East

North

Sud

West

]

where

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

;

Re: Filtering Data Load

Fri, 17 Mar 2017 19:48:37 GMT

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

Re: Filtering Data Load

vishsaggi — Fri, 17 Mar 2017 19:55:28 GMT

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;