19 Replies Latest reply: Sep 29, 2016 3:31 AM by Eric Hannert RSS

    calc date for data load[load editor]

    Eric Hannert

      Hi comm,

       

      i want to load data from the last 3 days.

      Thats why i want to get today - 3 days to get the date x. And with datex i want to load data into Qlik Sense!

       

      FROM Dashboard.dbo."QLIK_TF_SELL";

      WHERE Date(Date#(Date_new,'YYYY.MM.DD')) > Date(Date#('x', 'YYYY.MM.DD'))

       

      and x like i said is today -3d!!!

      Can i calc this with var in the script?

      thanks for help and advices in advance

      -Eric