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
