Qty in and Qty out on same time chart

[drorelkouby]

Hi,

I have the following data:

Order number	Date received	Date Completed	Qty
J1001	2023-01-01	2023-01-01	10
J1002	2023-01-01	2023-01-03	10
J1003	2023-01-02	2023-01-03	10
J1004	2023-01-03	-	10
J1005	2023-01-03	2023-01-04	10
...	...	...	...

(some orders can have a missing "Date Completed" if the order is still open, like in J1004)

I also have a calendar in my Data Load that is linked to the Date Completed field.

I'm trying to create a chart that will have one independent time line as dimension and with two trend lines.
One line to sum the Qty received on each date and one line to some the Qty completed on each date.
For example:

I prefer not to change my Data load or data structure unless i have no choice...

I'm sure there is an easy solution I'm missing.

Appreciate the help.

Thanks

Dror  

[ogster1974]

Remodelling your data is the way forward.

If you have multiple dates in your model to handle.  See below:

https://community.qlik.com/t5/Design/Canonical-Date/ba-p/1463578

[drorelkouby]

Thank you so much @ogster1974