Discussion board where members can get started with Qlik Sense.
I would like to create a line chart which shows the debt over the years.
My data is as follows:
DATE, DESCRIPTION, AMOUNT
31-12-2015, Debt I, 10.000
debt 31-12-2015 = 10.000
debt 31-12-2016 = 8.500 (10.000 minus 1.500)
How do I have to make this to put it in a line chart?
Thank you in advance!
in the load script create an extra field named something like totalamount with the value of amount + previous(amount)
in the chart you can then use debt - totalamount