Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
WernerDC
Creator
Creator

Monthly Budgeted amount into weeks Accumulated

Good day Fellow Qlickers.

Hope someone can help me with the following:

I have Budget values per month. I need to split this value equally into weeks and accumulate in to fit my current graph of accumulation.

Attached is a picture of the issue at hand (Screenshot 2021-08-13 at 08.32.57):

  • The black line (F2022 Budget) also needs to accumulate like the other 2 lines. Problem is that we budget per month. So I need to distribute the monthly amount evenly over the weeks of that said month and then let it accumulate.

Attached is a picture of the script where I pull in the Budget amount (Screenshot 2021-08-13 at 08.44.28):

 

I am more than happy to share the App if someone can help me?

 

Kind regards

 

0 Replies