Need help on Calculating YTD Value

Thu, 01 Dec 2016 11:27:20 GMT

Hi All,

Please help me in implementing below requirement:

I have below source file for three month:

For Jun Month:

GL Account	Description	MTD	YTD	MonthYear
1000	Capital	0.00	1,000.00	Jun-16
2000	Stock	0.00	2,000.00	Jun-16
3000	Salary	0.00	4,000.00	Jun-16
4000	Wage	0.00	6,000.00	Jun-16

For Jul Month:

GL Account	Description	MTD	YTD	MonthYear
1000	Capital	100.00	10,000.00	Jul-16
2000	Stock	40.00	5,000.00	Jul-16
3000	Salary	60.00	1,100.00	Jul-16
4000	Wage	0.00	2,000.00	Jul-16

For Aug Month:

GL Account	Description	MTD	YTD	MonthYear
1000	Capital	400.00	11,000.00	Aug-16
2000	Stock	50.00	8,000.00	Aug-16
3000	Salary	80.00	1,400.00	Aug-16
4000	Wage	100.00	6,000.00	Aug-16

So, YTD calculation for July month should be June month YTD value from source file + July Month MTD from source file. Here is the expected output:

July Output
GL Account	Description	MTD	YTD
1000	Capital	100.00	1,100.00
2000	Stock	40.00	2,040.00
3000	Salary	60.00	4,060.00
4000	Wage	0.00	6,000.00

But, YTD calculation for August month will be calculated YTD value in above output for July month + MTD value for August in source file. Here is the expected output:

August Output
GL Account	Description	MTD	YTD
1000	Capital	400.00	1,500.00
2000	Stock	50.00	2,090.00
3000	Salary	80.00	4,140.00
4000	Wage	100.00	6,100.00

Please help to achieve the above scenario in Qlikview.

Note :If above scenario we can achieve in Front end then it is too good because I am doing most of the calculation in Front End

Any help is appreciated!!!

Regards

Deepak

topic Need help on Calculating YTD Value in QlikView

Need help on Calculating YTD Value