topic Re: This Week and Last Week in QlikView

This Week and Last Week

satishkurra — Mon, 08 Aug 2016 20:12:52 GMT

I'm currently using the below boolean functions to get This Week and Last Week.

-InWeekToDate(Date,Today(),0) as CurrentWeek,

-InWeekToDate(Date,Today(),-1) as PreviousWeek,

For Current Week, it is showing Date as 08/08 and 08/07

and

For Last week, it is showing Date as 07/31 and 08/01.

I want to show Current Week from 08/07 - 08/13

and in the similar way Last week as well.

Can Someone help me in achieving this.

Besides this for Date Range Calculation i would like to use flag

For example, From Aug 1 - Aug 31 (full month Estimation using Flags)

I do not want Max(Date) as i have Dates after Aug 31 2016 as well

I need from Aug 1 2016 and Aug 31 2016 logic using Flags

Thanks

Satish

Re: This Week and Last Week

swuehl — Mon, 08 Aug 2016 20:18:35 GMT

Try using function InWeek() instead of InWeekToDate().

Re: This Week and Last Week

sunny_talwar — Mon, 08 Aug 2016 20:27:16 GMT

May be try this:

Table:

LOAD *,

InWeekToDate(Date, WeekEnd(Today()), 0) as CurrentWeek,

InWeekToDate(Date, WeekEnd(Today()), -1) as PreviousWeek;

LOAD Date(MonthStart(Today(), -1) + RecNo() - 1) as Date

AutoGenerate 44;

Re: This Week and Last Week

satishkurra — Mon, 08 Aug 2016 20:32:39 GMT

Both solutions worked...

Thanks

Also how can we get the logic using flags for Date Range.

For example, the data should be displayed from Aug 1 - Aug 31 (Using Flags)

Currently i'm using

InMonthToDate(Date, Today(), 0)

Can i replace the above to

InMonthToDate(Date, MonthEnd(today(), 0) ?

Re: This Week and Last Week

sunny_talwar — Mon, 08 Aug 2016 20:34:25 GMT

I feel that should work, what do you think Stefan?

Re: This Week and Last Week

satishkurra — Mon, 08 Aug 2016 20:36:05 GMT

It worked . But i will wait for you guys to confirm:)

Re: This Week and Last Week

sunny_talwar — Mon, 08 Aug 2016 20:38:23 GMT

Best way is to test it out

Using the script:

Table:

LOAD *,

InWeekToDate(Date, WeekEnd(Today()), 0) as CurrentWeek,

InWeekToDate(Date, WeekEnd(Today()), -1) as PreviousWeek,

InMonthToDate(Date, MonthEnd(Today()), 0) as CurrentMonth;

LOAD Date(MonthStart(Today(), -1) + RecNo() - 1) as Date

AutoGenerate 365;

Re: This Week and Last Week

swuehl — Mon, 08 Aug 2016 20:50:27 GMT

Satish Kurra wrote:

It worked . But i will wait for you guys to confirm:)

You want me to confirm what you already proved working? Why that?

It seems you like the more complex functions over the slighty more simple ones, note that there are a lot more functions to create flags for dates in the script, best to have a good read through the relevant date and time functions HELP pages.

Re: This Week and Last Week

raviteja475 — Tue, 02 Jul 2019 07:51:44 GMT

may i know what is meant by 0 and -1 present in table

Re: This Week and Last Week

raviteja475 — Tue, 02 Jul 2019 07:55:23 GMT

how to count previous week and present week transactions