topic WHERE & AND in QVD File creation in QlikView

WHERE & AND in QVD File creation

Fri, 08 Jul 2011 15:39:44 GMT

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......

WHERE & AND in QVD File creation

nagaiank — Fri, 08 Jul 2011 17:37:16 GMT

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

Miguel_Angel_Baeyens — Fri, 08 Jul 2011 17:44:02 GMT

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