Error: Function WeekStart Doesnot Exist. In Where clause

[berryandcherry6]

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

[tamilarasu]

Hi,

Sorry for the delayed response. I was busy yesterday and didn't have time to check your reply. Anyhow, Sunny is always there to help everyone.