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.