adding a monthly variable

[Graham_Warwick]

Hi All

I want to be able to add in a set amount of money each month to my qlikview dashboard so I can calculate it into my figures.

463.88 as [Car Repayment]

that is kinda what i wanted, but i know its going to be a little more complicated than that.  To give you some context the amount of £463.88 is to appear every month for the next three years, so that i can then calculate to include this in my monthly analysis.  So November 2018 i have an value of £463.88, December...... January 2019..... onwards.... 

I hope that makes sense, i know i havent explained it very well.

[Yousef_Amarneh]

You can create inline table in your script for the next 36 months, and then link it to your data model using year and month

Load Year & '|' & Month as Key,FixedAmount inline [Year,Month,FixedAmount

2018, 11, 463.88

2018, 12, 463.88

2019, 1, 463.88

....

....

];