5 Replies Latest reply: Jul 14, 2016 3:43 AM by Dmitry Lapchenkov RSS

    qlik sense store procedure with variable

    Dmitry Lapchenkov

      Hi!

      I have problem with load data from store procedure.

       

      like this works fine:

      -------------------------------------------------------------------------

      load

      *;

       

      SQL

      exec TS.dbo.P_profil_fil '20160601','20160630';

      ------------------------------------------------------------------------

      But when i try use variable from qlik sense

       

      vNP = date(min([date task]),'YYYYMMDD')

       

      v KP = date(max([date task]),'YYYYMMDD') 

       

      and load script:

       

      load

      *;

       

      SQL

      exec TS.dbo.P_profil_fil '$(vNP)','$(vKP)';

       

      not working and looks like:

       

      exec TS.dbo.P_profil_fil 'date(min([date task]),''YYYYMMDD'') ','date(max([date task]),''YYYYMMDD'') '


      but i need value in argument not formula


      what i missed?