Where statement Last Week Start

[#1]

How do I change this statement to give say Last week start<weekstart today? Any assistance greatly appreciated.

where weekstart(Week)<weekstart(today());

Be Well,

(O)nePuttGirl

[CELAMBARASAN]

Hi,

     Not able to understand clearly about the problem?Can you explain little more?

Celambarasan

[#3 · Accepted solution]

I am new to Qlikview and would just like the following: take todays date and subtract ten days which is the start of last week as make it field [Week].  I also have a let statement LET vLastWeekStart = $(vLastWeek) - 1; so if I can incorporate the variable I would like to. Any thoughts? Thank you in advance.

num(today())-10 as Week

[jagan]

Hi,

Try this

=WeekStart(Today(), -1)

returns the previous week start date.

Hope this helps you.

Regards,

Jagan.

[#5]

Thank you for taking the time to anwser!