topic Re: QlikView Multiple Where Clause In Load Script in Qlik Learning Discussions

QlikView Multiple Where Clause In Load Script

Wed, 25 Feb 2015 16:40:59 GMT

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 — Wed, 25 Feb 2015 21:05:18 GMT

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 — Wed, 25 Feb 2015 21:10:46 GMT

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 — Wed, 25 Feb 2015 21:53:11 GMT

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.