topic Week intervals per Period in QlikView

Week intervals per Period

Tue, 01 Oct 2013 13:12:14 GMT

Hi There,

I have a challenge where i am trying to get Week Numbers per a certain period. I have already got the periods into Qlikview as per attached but now i need the Week Breakdown per Period. I would like to name it PeriodWeek and it should say 1-1, 1-2, 1-3, 1-4, 2-1, 2-2, 2-3, 2-4 etc etc

I have the Fiscal Calendar attached.

Please advise or let me know if this is not clear,

Thanks Again, It is appreciated.

Re: Week intervals per Period

Gysbert_Wassenaar — Tue, 01 Oct 2013 16:20:28 GMT

Try something like this:

Load *, Period & '-' & WeekNo as PeriodWeek;

Load

ceil(week([MyDate])/4) as Period,

1+mod(week([MyDate])-1,4) as WeekNo,

...other fields...

From ...mysource...;

Re: Week intervals per Period

Wed, 02 Oct 2013 11:54:32 GMT

Hi G,

Thanks for your reply, i've actually figured it out by manually creating a flag in excel linking the weeks to the Transaction Date itself. A bit tedious but it works.