topic Re: Excluding Rows on Load with WHERE AND in QlikView

Excluding Rows on Load with WHERE AND

tomdabek — Wed, 23 Mar 2016 13:37:25 GMT

Hi, New user to Qlikview and trying to exclude certain rows with my load statement:

LOAD

..........

FROM [$(vPath)\*.xlsx]

(ooxml, embedded labels, table is QLIK)

WHERE NOT WildMatch ([Plant Number] , '10844', '10846')

OR (NOT [Plant Number] = '20531' AND [Material Number] = 'AG6604');

The 1st part works, any entry in the data where [Plant Number] is 10844 or 10846 is excluded

However, all records for [Plant Number] 20531 are excluded when I only want the ones where the [Material Number] is AG6604 excluded

I have tried a few combinations but am unable to figure out how to exclude loading a row using a rule that includes two (or more) of the columns in the criteria.

Thank You

Re: Excluding Rows on Load with WHERE AND

Gysbert_Wassenaar — Wed, 23 Mar 2016 16:22:13 GMT

Try this:

WHERE NOT WildMatch ([Plant Number] , '10844', '10846')

OR ( [Plant Number] <> '20531' AND [Material Number] <> 'AG6604');

Re: Excluding Rows on Load with WHERE AND

tomdabek — Wed, 23 Mar 2016 16:42:10 GMT

Thank You,

I must have misrepresented my original question, but your solution is correct except I changed the "OR" to "AND" to apply the filter to both situations I am trying to prevent from loading.

WHERE NOT WildMatch ([Plant Number] , '10844', '10846')

OR AND ( [Plant Number] <> '20531' AND [Material Number] <> 'AG6604');