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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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!