topic Re: Variable Qlikview in SQL Select in QlikView

Variable Qlikview in SQL Select

odaher123 — Fri, 02 Nov 2018 09:42:52 GMT

Hello everyone,
How with a SQL connection, recover data that has not been repatriated since the last connection and are stored in a QVD file (Ecritures.qvd)?
I can not use the $ (Maxpiece) variable with the SQL SELECT statement with the Where condition.
You will find below my script which does not accept the variable
thank you for your help

========================

LOAD

Max(EC_No) as Maxpiece,

FROM

(qvd);

ODBC CONNECT TO BASE_LOCAL2 (XUserId is bbbRdYRNJbaMXUVMXTcB, XPassword is vvVYaRdNrLacWXJObA);

Ecritures:

SQL SELECT *

FROM ACHATS.dbo."ECRITURES"

Where (EC_No > $(Maxpiece));

============================================

Re: Variable Qlikview in SQL Select

rubenmarin — Fri, 02 Nov 2018 09:46:42 GMT

Hi Olivier, in that code Maxpiece is a field, not a variable, you can create a variable of that field value:

LET vMaxpiece = Peek('Maxpiece',0);

And use this variable in where:

Where (EC_No > $(vMaxpiece));

Re: Variable Qlikview in SQL Select

odaher123 — Fri, 02 Nov 2018 15:17:09 GMT

Hi Ruben
Thank you for your answer, it was almost correct but it did not work. I found in the meantime how to do it and here is the solution.

LOAD

Max(EC_No) as MaxNo,

FROM

(qvd);

Let Maxpiece = peek(‘MaxNo’) ;

ODBC CONNECT TO BASE_LOCAL2 (XUserId is bbbRdYRNJbaMXUVMXTcB, XPassword is vvVYaRdNrLacWXJObA);

Ecritures:

SQL SELECT *

FROM ACHATS.dbo."ECRITURES"

Where (EC_No > $(Maxpiece));

Re: Variable Qlikview in SQL Select

rubenmarin — Sat, 03 Nov 2018 19:13:28 GMT

Your original post calls that field 'Maxpiece', not 'MaxNo'