Hi everyone, we recently moved from QlikView to Qlik Sense and an order changes table was created to look at daily changes in order value. I've been tasked with finding out why the values don't match from day-to-day.
There's a daily, weekly and a financial period values. Period value is supposed to take into account the daily total and then roll that over everyday until the end of that period.
But these figures don't match daily when added together, there's usually a decrease, not sure if it is the way the table is set, up which is why I've attached the script for context.
Any suggestion or insight would be deeply appreciated.
