Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Just by reading script this is very hard, sorry
You need to check many ways..
Starting form the script data model.. expressions ..how it is linked and all
Cna u give us some sample