Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

adoteykwame
Contributor

Where clause issue

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';

1 Solution

Accepted Solutions
Not applicable

Re: Where clause issue

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

2 Replies
Not applicable

Re: Where clause issue

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

er_mohit
Honored Contributor II

Re: Where clause issue

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

means in preceding load

like

load A,

B

where B=10;

load * from foxpro.db;

Community Browser