- Outstanding orders which are confirmend and waiting to be shipped as Orderportfolio
The Nett Amount is based on the InvoiceCalender, which is the date when an order has been invoiced.
The Orderportfolio is based on the ShipmentCalender, which is the date when the order is planned to ship.
*Note: both calendars are based on the same MasterCalendar.
I want the sum of these variables, so I'm able to figure out what the total sales of a certain month will be.
I tried to sum these two measures in my loading script in Qlik Sense. With this calculation, I found the right Nett Amount, but the Orderportfolio has been measured by the date the order has been added to our system (which is wrong).
Which function/expression should I use to sum these two variables, sorted by the two calendars?
And should I do this in my loading script or in the bar chart?