topic Where statement Last Week Start in QlikView

Where statement Last Week Start

Thu, 03 May 2012 18:37:30 GMT

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

Where statement Last Week Start

CELAMBARASAN — Thu, 03 May 2012 19:16:37 GMT

Hi,

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

Celambarasan

Where statement Last Week Start

Thu, 03 May 2012 19:21:32 GMT

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

Where statement Last Week Start

jagan — Fri, 04 May 2012 05:36:09 GMT

Hi,

Try this

=WeekStart(Today(), -1)

returns the previous week start date.

Hope this helps you.

Regards,

Jagan.

Where statement Last Week Start

Fri, 04 May 2012 14:17:41 GMT

Thank you for taking the time to anwser!