topic Re: sql where statment using variable in QlikView

sql where statment using variable

Wed, 01 Apr 2015 17:27:44 GMT

I am have problem, when I use the variable

let vExecTime='2015-03-25' in a load sql select statment,

sql where statement (WHERE MODIFIED < '$(ThisExecTime)')

return 0 records from sql table while when replace variable with '2015-03-25' sql select statmen works?

Re: sql where statment using variable

MK_QSL — Wed, 01 Apr 2015 17:28:26 GMT

MODIFIED should be in YYYY-MM-DD format !

Also check < or > depending upon your requirements.

Re: sql where statment using variable

anbu1984 — Thu, 02 Apr 2015 07:35:37 GMT

Is it because you used wrong variable name in Sql??

(let vExecTime='2015-03-25' in a load sql select statment,)

sql where statement (WHERE MODIFIED < '$(ThisExecTime)')

Re: sql where statment using variable

Anonymous — Thu, 02 Apr 2015 07:46:05 GMT

Try sql where statement (WHERE MODIFIED < '$(vExecTime)')

Re: sql where statment using variable

Thu, 02 Apr 2015 13:19:08 GMT

anbu got it right! that was the fix;

I am trying to create a QVW that does incremental loads of large SQL tables that get updated daily.

The scripting in Re: Re: Incremental Load Script

for case 4 worked fine until I added a second set of data (different SQL table) to save a 2nd QVD. The script runs correctly for the 1st incremental load and creates an updated QVD then drops/ at end of second table right as it starts to store the 2nd QVD that has an incremental load with same scripting in case 2 (Load Insert/Update/Delete).

Re: sql where statment using variable

Thu, 02 Apr 2015 13:20:39 GMT

anbu got it right! that was the fix;

I am trying to create a QVW that does incremental loads of large SQL tables that get updated daily.

The scripting in Re: Re: Incremental Load Script