topic Re: DateDiff function to load data in QlikView

DateDiff function to load data

Tue, 30 Jul 2013 12:06:03 GMT

Dear All,

We are using MSSQL as our data source, we could connect to the SQL server from QV.

We are now trying to load our data from the SQL server. we are using the following query in the Edit script to load data for the next 90 days, however we are getting error while we reload the script.:

SNAPSHOT:

LOAD snapshotdate,

potentialid,

amount,

closingdate,

Ceil(Month(closingdate)/3) as Quarter,

"sales_stage" AS snap_salesstage;

SQL SELECT * FROM "vtiger_crm".dbo.snapshot

//where (closingdate-snapshotdate <=90) and (closingdate>=snapshotdate);

where DATEDIFF(DD,snapshotdate,<=90) and (closingdate>=snapshotdate);

Re: DateDiff function to load data

ariel_klien — Tue, 30 Jul 2013 12:12:54 GMT

Hi,

What kind of Error?

Can you send us the Error?

Ariel

Re: DateDiff function to load data

Tue, 30 Jul 2013 12:20:41 GMT

in qlikview write this

simply write your where condition with load statement

SNAPSHOT:

LOAD snapshotdate,

potentialid,

amount,

closingdate,

Ceil(Month(closingdate)/3) as Quarter,

"sales_stage" AS snap_salesstage

//where (closingdate-snapshotdate <=90) and (closingdate>=snapshotdate);

where DATEDIFF(DD,snapshotdate,<=90) and (closingdate>=snapshotdate);

SQL SELECT * FROM "vtiger_crm".dbo.snapshot ;

Re: DateDiff function to load data

Tue, 30 Jul 2013 12:28:42 GMT

We tired the above resolution and we are getting the following error:

Error in expression:

DATEDIFF is not a valid function

SNAPSHOT:

LOAD snapshotdate,

potentialid,

amount,

closingdate,

Ceil(Month(closingdate)/3) as Quarter,

"sales_stage" AS snap_salesstage

where DATEDIFF(DD,snapshotdate,closingdate)<=90