topic Re: selection for last week in QlikView

selection for last week

Fri, 05 Dec 2014 10:58:49 GMT

Hi experts

I have the following statement giving me entries of the last month:

LOAD *, stunden_1w*stdsatz_alt1W as X_1w;

Load

jobnr,

stunden as stunden_1w,

stdsatz_alt as stdsatz_alt1W

resident Stunden where datum > Date(AddMonths(Today(),-1));

How can I get only values from last weeg?

Best

Jan

yduval75 — Fri, 05 Dec 2014 11:00:51 GMT

LOAD *, stunden_1w*stdsatz_alt1W as X_1w;

Load

jobnr,

stunden as stunden_1w,

stdsatz_alt as stdsatz_alt1W

resident Stunden where datum > Weekstart(Today(),-1);

mato32188 — Fri, 05 Dec 2014 11:03:41 GMT

Hi Jan,

where week(datum) = week(today())-1

tresB — Fri, 05 Dec 2014 11:03:56 GMT

Or, (if you want only last week data)

resident Stunden where datum >= Weekstart(Today(),-1) and datum <Weekstart(Today());

Edit: corrected

yduval75 — Fri, 05 Dec 2014 11:06:50 GMT

Indeed, but I think there is perhaps a mistake in your syntax

resident Stunden where datum >= Weekstart(Today(),-1) and datum < Weekstart(Today());

tresB — Fri, 05 Dec 2014 11:09:04 GMT

Like this, year check will fail.

mato32188 — Fri, 05 Dec 2014 11:46:36 GMT

Sorry man, of course, you are right...