topic Re: How can I transfer a QlikView variable to a SQL statement? in QlikView

How can I transfer a QlikView variable to a SQL statement?

Wed, 17 Oct 2012 13:56:01 GMT

Hello

My document (qvw file) has a connection with a MS-SQL database.

In my script I use SQL statements like

Customer:
SQL
Select * from Customer;

Suppose I've a variable StartDate

SET StartDate=MakeDate(2012,01,01);

Is there a way to use the variable StartDate in a SQL statement?

Customer:
SQL
Select * from Customer where Customer.Date >= StartDate;

I understand that in this example I better switch to QlikView syntax but I've fairly complex SQL statements that are hard to translate.

Gysbert_Wassenaar — Wed, 17 Oct 2012 14:08:58 GMT

Try this:

Customer:

SQL

Select * from Customer where Customer.Date >= '$(StartDate)';

nstefaniuk — Thu, 18 Oct 2012 07:26:10 GMT

Hi, it's an issue of format.

do something like that:

vDateString=Year( StartDate )&num(Month( StartDate ))&Day( StartDate );

Customer:

SQL

Select * from Customer where Customer.Date >=

CONVERT(datetime, '$(vDateString'), 112)

Fri, 19 Oct 2012 09:43:18 GMT

Thank you

Fri, 19 Oct 2012 09:43:43 GMT

Thank you