10 Replies Latest reply: Dec 29, 2016 9:46 PM by Tamil Nagaraj RSS

    Error: Function WeekStart Doesnot Exist. In Where clause

    Supriya R

      Hi,

       

      I am executing below script in Qliksense, to get data for previous week in table.

       

      LOAD `help_request_id`,    

          status,

          Date(date_created,'DD-MM-YYYY') as Format_Date;

      SQL SELECT `help_request_id`,

          status,

          `date_created`

      FROM sdasa.HELPREQUESTS WHERE date_created >= Date(WeekStart( Today()-7)) and date_created <= Date(WeekEnd( Today()-7));

       

      But above Script throws Error: Function WeekStart Doesnot Exist.

       

       

       

      Regards,

      Supriya