How to add the Old Balance with the Selected Values Balance to get the result
Hello,
Please Help me on this b'coz i have to submit it in next two hours and I'm badly stuck at this as I'm very new to qlik....
I have refered with an example, like if i select data from jan 2015 to Dec 2015 the total of amount in that year is 100 and the Old balance amount before 2015 is for the year 2014 which is also 100.
Hence the Total result should be 200 considering Old Balance and Current selection Balance.
Date
Year
Doc_Num
Amount
01-01-2014
2014
1
200
30-03-2014
2014
2
-100
01-01-2015
2015
4
300
30-12-2015
2015
5
-200
01-04-2016
2016
7
500
I'm really stuck at this point please help team, I'm very new to Qlik.
I have attached the app and screenshot of the requirement for reference.