topic Re: Exclude current week in QlikView

Exclude current week

stekol61 — Fri, 03 Aug 2018 13:03:54 GMT

Hi!

I'm loading data and converts 'Date' to 'Week' as below .

How can I always exclude the current week when data is loaded?

LOAD

Year(event_start_time)&'-'& Week (event_start_time)as Week,

sunny_talwar — Fri, 03 Aug 2018 13:13:40 GMT

May be this

Where WeekStart(event_start_time) <= WeekStart(Today());

petter — Fri, 03 Aug 2018 13:14:23 GMT

You could filter by a

LOAD

....

.....

FROM

....

WHERE

event_start_time < WeekStart(Today(1));