topic Re: Recent 4 fiscal weeks excluding this week in QlikView

Recent 4 fiscal weeks excluding this week

markgraham123 — Tue, 15 Sep 2015 18:30:30 GMT

Hi all,

I have a master calendar, where i load fiscal week and fiscal date.

I want to load a new dimension where it contains the recent 4 fiscal weeks but not this week.

Can someone pls help me on this.

current fiscal week statement i'm using.

if(week(SoldDate) > 5,week(SoldDate)-5, week(SoldDate) + 47) as [Fiscal Week]

Re: Recent 4 fiscal weeks excluding this week

sunny_talwar — Tue, 15 Sep 2015 22:08:40 GMT

Not sure if I understand completely, but may be this:

If(Match(Week(SoldDate), Week(Today())-1, Week(Today())-2, Week(Today())-3, Week(Today())-4), Week(SoldDate)) as [Fiscal Week]

Re: Recent 4 fiscal weeks excluding this week

markgraham123 — Tue, 15 Sep 2015 22:10:41 GMT

Thanq Sunny...

Welcome back bro.

Re: Recent 4 fiscal weeks excluding this week

sunny_talwar — Tue, 15 Sep 2015 22:12:30 GMT

No problem Mark

I am glad that I am able to help you.

Best,

Sunny

Re: Recent 4 fiscal weeks excluding this week

markgraham123 — Wed, 16 Sep 2015 13:22:57 GMT

Sunny, i have a small question.

The last weeks were showing for both 2014 and 2015. We need it only for 2015.

I tried giving the condition Max(year) and '2015' in If condition but its just loading nothing.

Re: Recent 4 fiscal weeks excluding this week

sunny_talwar — Wed, 16 Sep 2015 13:25:50 GMT

May be this:

If(Match(Week(SoldDate), Week(Today())-1, Week(Today())-2, Week(Today())-3, Week(Today())-4) and Year(SoldDate) = Year(Today()), Week(SoldDate)) as [Fiscal Week]

Re: Recent 4 fiscal weeks excluding this week

markgraham123 — Wed, 16 Sep 2015 14:06:52 GMT

Hi Sunny,

It worked.

I tried in the other way, which too worked:

If([SoldDate]>= (Today()-28) and [SoldDate] < (Today()),Week([SoldDate])) as [Last 4 Weeks]

Thank you again buddy