QlikView Multiple Where Clause In Load Script

[#1]

Hello,

I am having a difficult time getting this syntax to run correctly in my qlikview load script:

(

qvd) where not match (SKM_DISCONTINUED, 'Y') and SKM_FAMILY != 'No';

what am I doing wrong? It appears that the last statement is not working.

[m_woolf]

Where clause doesn't work with QVDs.

Load all the records and put your where in a preceding load.

load

     *

where ................;

load

     *

from Your.qvd;

[maxgro]

where clause works with qvd

but it should be changed (bold)

test:

load  * inline [

SKM_DISCONTINUED, SKM_FAMILY

Y,Yes

Y,No

N,Yes

N,No

];

store test into test.qvd (qvd);

drop table  test;

load * from test.qvd (qvd)

where not match (SKM_DISCONTINUED, 'Y') and SKM_FAMILY <> 'No';

[Anonymous]

I'm just curious, why not to be consistent and use either this:

where not match (SKM_DISCONTINUED, 'Y') and not match(SKM_FAMILY, 'No');

or that:

where SKM_DISCONTINUED <> 'Y'  and SKM_FAMILY <> 'No';

???

I know it doesn't add any value, but at least looks a bit more organized.