How to add the Old Balance with the Selected Values Balance to get the result

[tahreen371]

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.

[jyothish8807]

Hi Thareen,

Try this. Hope it will help.

[tahreen371]

Actually that's not the requirement....  I need to sum account transactions from the beginning of time to the current Year-Month selection  in the Lable of straight table

I have also attached the Screenshot of the requirement. Please assist

Regards