Date period to separate months

[Ernests]

Hi Experts!

I have a table filled with IDs, Amount and period (please see screenshot).

I need to distribute amount to count of months, for example, for ID (= 2) I would divide Amount (= 500) by Count of months (= 5). So in each month in particular period there would be Amount = 100. 

Problem: I do not understand how I could represent it graphically, because the dimension should be month/quarter. I have only period dates.

Thanks!

[Or · Accepted solution]

This is typically done in script using a While... load to create a row for each month in the range. See e.g. https://community.qlik.com/t5/QlikView-App-Dev/how-to-split-a-row-start-date-end-date-into-months-to...

[Ernests]

@Or Thank you! I was looking for this.