Week intervals per Period

[#1]

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.

[Gysbert_Wassenaar]

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...;

[#3]

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.