topic Re: Where clause issue in QlikView

Where clause issue

Anonymous — Fri, 24 May 2013 16:21:50 GMT

Initially when i was loading from QVD, these where clauses work sucesssfully, but now the script hangs when i load from the foxpro .db

WHERE LEFT(clicod,1) = 'B';

WHERE NOT clicod = 'IN' and NOT LEFT(clicod,1) = 'B';

Fri, 24 May 2013 17:42:36 GMT

Maybe with : WHERE clicod <> 'IN' and LEFT(clicod,1) <> 'B';

er_mohit — Fri, 24 May 2013 19:19:15 GMT

try to work this Code before Load Your Table from foxpro.db

means in preceding load

load A,

where B=10;

load * from foxpro.db;