Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Running Balance calculation issue in middle of running balance- resets?

Re: Rangesum - Running Balance by Dimension

The link above gave me great help to get my running balance working but when i went to validate, there are 3-4 groupings where the balance "loses its way" - See yellow highlight on Attached Excel

As you can see from the attached QVW, 99.5% of the balances are tracking perfectly except for 3-4 items where it calculates perfect then in the middle, the calculation seems to just "reset".   Odd thing is when I drill into those records (by dates 5/24/16 & 5/25/16, the running balances work.

Another balance error is in Warehouse 120

In the QVW there is a Bookmark for the Drill Down

12 Replies
Anonymous
Not applicable
Author

Transaction Date is a dimension like any other... above(total) is just the line above ... not more not less

Off course you try to find a lucid explanation... but I still think there isn't one...

Not applicable
Author

This was confirmed to be a bug in 11.2 SR15

Tech Support said they opened my document in 12.x and it worked.

Anonymous
Not applicable
Author

Thanks for your feedback!