Discussion Board for collaboration on QlikView Layout & Visualizations.
Was hoping someone would be able to help me with a pivot chart issue i am having.
Little background, I'm trying to show the "ultimate" value of the customer after they've received all their deductions to see how much is left. Basically a running total.
The end value of the customer is 5522.75 and i am trying to show this horizontally in a pivot with a cyclical group going vertically.
using the below formula my end result is incorrect at -109.25
Does anyone have any suggestions?
It seems you need to adjust to the horizontal view with something like:
Thanks, works a treat.