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

       

       

      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 ?