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.
Where clause doesn't work with QVDs.
Load all the records and put your where in a preceding load.
where clause works with qvd
but it should be changed (bold)
load * inline [
store test into test.qvd (qvd);
drop table test;
load * from test.qvd (qvd)
where not match (SKM_DISCONTINUED, 'Y') and SKM_FAMILY <> 'No';
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');
where SKM_DISCONTINUED <> 'Y' and SKM_FAMILY <> 'No';
I know it doesn't add any value, but at least looks a bit more organized.
Retrieving data ...