2 Replies Latest reply: Dec 18, 2013 11:10 AM by Thiago Costa RSS

    sql data in variable

      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'));





        SELECT MAX(Data) as Dstx FROM time_dimension;



      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 ?