Hello Qlik Guys,
I'm unable to create the carry forward or Opening balance measure in qlik.I have attached the source data in below attachement
And i want to show the source data into below format
| Year | Month | Module | Priority | Request Type | Organization | Open Balance | Created Tickets | Closed Tickets | Closing Balance |
|---|
| 2017 | Feb | SD | L2 | New Request | Corporate | 0 | 5 | 0 | 5 |
| 2017 | Feb | SD | L4 | New Request | Corporate | 0 | 1 | 0 | 1 |
| 2017 | Feb | FI | L2 | | Corporate | 0 | 2 | 0 | 2 |
| 2017 | Feb | MM | L2 | New Request | Corporate | 0 | 5 | 0 | 5 |
| 2017 | Mar | SD | L1 | New Request | Corporate | 0 | 1 | 1 | 0 |
| 2017 | Mar | SD | L1 | Production Issue | Corporate | 0 | 4 | 0 | 4 |
| 2017 | Mar | SD | L2 | New Request | Corporate | 5 | 3 | 1 | 7 |
| 2017 | Mar | MM | L2 | New Request | Corporate | 5 | 0 | 1 | 4 |
Like this i want to show in pivot table but i'm not able to achieve this . Please help me in this.
Thanks and Regards
M Subash
