Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
WHERE NOT WildMatch ([Plant Number] , '10844', '10846')
OR ( [Plant Number] <> '20531' AND [Material Number] <> 'AG6604');
Try this:
WHERE NOT WildMatch ([Plant Number] , '10844', '10846')
OR ( [Plant Number] <> '20531' AND [Material Number] <> 'AG6604');
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');