Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
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
laurafinn
Contributor III
Contributor III
Author

1 Reply
laurafinn
Contributor III
Contributor III
Author