topic Re: sql data in variable in QlikView

sql data in variable

Mon, 26 Jan 2026 18:19:17 GMT

Hi everyone !

I need to bring one value (date) from sql server to a variable in qlikview and after make a tratative this of data , the problem is that variable always stay null.

follow part of the code

LET MinDate = floor(date(VStartAno, 'DD/MM/YYYY'));

cld_temp:

SQL

SELECT MAX(Data) as Dstx FROM time_dimension;

xtemp:

LOAD floor(date(Dstx ,'DD/MM/YYYY'))

Resident cld_temp;

LET MaxDate = Dstx;

DROP TABLE cld_temp;

DROP TABLE xtemp;

the maxdate stay null, and would should to stay like 41630.

someboy have some idea ?

Re: sql data in variable

Gysbert_Wassenaar — Wed, 18 Dec 2013 14:32:44 GMT

Try using the peek function:

LET MinDate = floor(date(VStartAno, 'DD/MM/YYYY'));

cld_temp:
SQL SELECT MAX(Data) as Dstx FROM time_dimension;

LET MaxDate = peek('Dstx');

drop table cld_temp;

Re: sql data in variable

Wed, 18 Dec 2013 16:10:39 GMT

worked, thanks!!