Dividing a total value over 12 months

[Jaden]

Hi all,

I have a question that revolves around creating months and attaching a value to them.

• What I have: 
  • Start Date
  • End Date (12 months in the future)
  • Estimated Volume
• What I need:
  • To create the 12 months between these two dates and add (Estimated Volume / 12) to these records.

For example:

Start Date	End Date	Estimated Volume
1/1/2025	12/1/2025	120

Taking the above and turning it into this:

Month Year	Estimated Monthly Volume
Jan-25	10
Feb-25	10
Mar-25	10
Apr-25	10
May-25	10
Jun-25	10
Jul-25	10
Aug-25	10
Sep-25	10
Oct-25	10
Nov-25	10
Dec-25	10

Any advice would be appreciated. Thank you.

[marcus_sommer]

Maybe something like this:

t: load
    date(addmonths(StartDate, iterno() -1), 'MMM-YY') as MonthYear,
    Volume / 12 as Volume
from Source while iterno() <= 12;

[Jaden · Accepted solution]

After much research, I found a solution to this issue using Crosstables. See here:

Solved: Equally distribute the Total Value across months b... - Qlik Community - 655637