Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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.

Not applicable

WHERE & AND in QVD File creation

Hi to all,

I,m working with QV Perssonal Edition and tryng to create a QVD File "Insert Only", but WHERE & AND Statement does not working, see below the script.

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=baan;Data Source=baan_10.72.102.100;Extended Properties=""] (XPassword is XXXXXXXXXXXXXXXXXXXXXXXX);

QVD_Table:

SQL SELECT* FROM BAAN.TTDSLS824804

     WHERE ModificationTime >= #$(LastExecTime)#

     AND ModificationTime<#$(BeginningThisExecTime)#;

Concatenate

LOAD* FROM Sales.qvd;

STORE QVD_Table into Sales.QVD;

How you can see the WHERE & AND are not in BLUE,

Any Idea abuot why this issue?

Thanks in Advence......

2 Replies
nagaiank
Valued Contributor III

WHERE & AND in QVD File creation

I think (though I am not certain about this) that any command after the SQL prefix is expected to be a valid SQL statement and Qlikview script editor does not validate the syntax of SQL statement, though it validates/checks syntax of Qlikview script.

WHERE & AND in QVD File creation

Hi,

First, it seems to be an OR instead of an AND, since a single field cannot store more than one value.

Make sure both ModificationTime field and variables have the same date format and that this format is allowed into a raw SQL statement in your database's query analyzer.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Community Browser