Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
laurafinn
Contributor III
Contributor III

Adding cumulative week of year from a file with only Month and Year

Hi all,

I have searched the many Q&A's relating to this question and unfortunately I can't get any of the solutions to work for my specific problem, please help!

Attached is the annual budget file, it contains a category for the particular budget line, the month and year as the date and the budget for that budget line and month (I've dummied the budget data) on "sheet 1"

On "sheet 2" I've added what I'd like the transformed data to look like (I've only dummied the data for Jan but I'd like it to do the same thing for the whole year).

Essentially, I need to split out the monthly budget data into weeks, week 1-week 52 for the year so we can track spend against budget on a weekly basis. 

The RC monthly budget line of £20 becomes £4 if there are 5 weeks in the month.

I don't want the weekly recount to restart at the beginning of each month, it should run right through to 52 

Any help would be much appreciated at this point 🙂

Labels (1)
1 Solution

Accepted Solutions
1 Reply
laurafinn
Contributor III
Contributor III
Author