Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
....
....
];