topic Re: Load with 2 where clauses in QlikView

Load with 2 where clauses

Anonymous — Tue, 19 Mar 2013 16:02:19 GMT

Hi,

Could someone please help me with this syntax i get an error when it executes

LOAD

clicod,

SQL SELECT *

FROM PAB

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

alexandros17 — Tue, 19 Mar 2013 16:03:24 GMT

the second where in unuseful

SQL SELECT *

FROM PAB

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

Tue, 19 Mar 2013 16:14:15 GMT

SQL SELECT *

FROM PAB

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