topic Re: Database system Load on data selection in QlikView

Database system Load on data selection

Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I have a script where data can be loaded based on the date selection:

ODBC CONNECT TO [ASBASE.nlgo.prod;DBQ=ASBASE.nlgo.prod] (UserId is XFT12, Password is UtRWs);
Charge:
LOAD STARTTMS,PROCESORDER
WHERE STARTTMS >= '01-08-16' AND AFDELINGNR = '402';
SELECT
AFDELINGNR,
STARTTMS,
PROCESORDER
FROM TRACK."CB_CHARGE";

The above script works excellent.

If I have defined a variable:

Let eStart_ASBASE = NOW()-2;

WHERE STARTTMS >= $(eStart_ASBASE) AND AFDELINGNR = '402';

this works also very good.

But NOT:

Let eStart_ASBASE = '01-08-16';

WHERE STARTTMS >= $(eStart_ASBASE) AND AFDELINGNR = '402';

there is no error reporting from QV however, the generated table contauins a list of all available date instead >= 01-08-16.

I have already tried this:

Let eStart_ASBASE = Date#('01-08-2016', 'DD-MM-YY');

But no solution, so far.

Any idea how to tackle this problem?

Best regards,

Cornelis

Re: Database system Load on data selection

swuehl — Mon, 12 Sep 2016 06:11:34 GMT

Try with single quotes around the variable expansion:

Let eStart_ASBASE = '01-08-16';

WHERE STARTTMS >= '$(eStart_ASBASE)' AND AFDELINGNR = '402';

Re: Database system Load on data selection

Mon, 12 Sep 2016 06:17:49 GMT

Hi Stefan,

Yes!

I have misunderstood the color of the script. Putting into quotation mark will turn variable from gray to black and I thought is was an error, but actually not.

thank you for your swift reply.

Best regards,

Cornelis