topic Re: Let Statement in QlikView

Let Statement

hkg_qlik — Fri, 18 Mar 2016 18:07:39 GMT

Hi,

I am trying to define a variable as follows:

Let vStartDate = '01-JAN-16';

Let vLimit = 'TO_DATE('$(StartDate)', 'DD-MON-YY')';

When I am trying to load the variables I am getting the following error :

Can someone help me with the correct syntax ?

Regards,

swuehl — Fri, 18 Mar 2016 18:18:23 GMT

TO_DATE is not a Qlik script function, and your statement itself does not evaluate to a valid statemten because of the quoting.

Try

Let vLimit = Date#('$(vStartDate)','DD-MMM-YY');

maxgro — Fri, 18 Mar 2016 20:06:02 GMT

do you need a vLimit var for an Oracle where clause or something similar?

Let vStartDate = '01-JAN-16';

Set vLimit = TO_DATE('$(vStartDate)', 'DD-MON-YY');

hkg_qlik — Fri, 18 Mar 2016 20:13:27 GMT

Yes Maxgro.

SQL Select ......

From ......

Where Transaction_Date >= $(vLimit)

maxgro — Fri, 18 Mar 2016 20:22:05 GMT

did you try my prev post?

Let vStartDate = '01-JAN-16';

Set vLimit = TO_DATE('$(vStartDate)', 'DD-MON-YY');

trace $(vLimit);

SQL Select ......

From ......

Where Transaction_Date >= $(vLimit)

or with quote

'$(vLimit)'