https://community.qlik.com/t5/QlikView/How-to-get-total-sum-of-different-quantity-products-for-each/m-p/2005306#M1221518 <P><SPAN>My in my case one Item assigned with OrderID</SPAN><SPAN>&nbsp;may&nbsp; have quantity more than 1. For example one item with 2 quantity has been ordered</SPAN></P> <P><SPAN>My fields are&nbsp; </SPAN></P> <P><SPAN>1) date flag which have delivered and dispatched</SPAN></P> <P><SPAN>2) Quantity&nbsp;</SPAN></P> <P><SPAN>3) orderID</SPAN></P> <P><SPAN>4) date field as logistic_date&nbsp;</SPAN></P> <P><SPAN>however i am able to count order ID using flag and able to plot it on weekly basis.</SPAN></P> <P><SPAN>kindly help me to figure out&nbsp;</SPAN></P> <P><SPAN>How should I calculate sum of&nbsp; quantity&nbsp; with different flag like delivered and dispatched on weekly and daily basis?</SPAN></P> <P>&nbsp;</P> Wed, 16 Nov 2022 13:23:00 GMT gary5 2022-11-16T13:23:00Z https://community.qlik.com/t5/QlikView/How-to-get-total-sum-of-different-quantity-products-for-each/m-p/2005306#M1221518 <P><SPAN>My in my case one Item assigned with OrderID</SPAN><SPAN>&nbsp;may&nbsp; have quantity more than 1. For example one item with 2 quantity has been ordered</SPAN></P> <P><SPAN>My fields are&nbsp; </SPAN></P> <P><SPAN>1) date flag which have delivered and dispatched</SPAN></P> <P><SPAN>2) Quantity&nbsp;</SPAN></P> <P><SPAN>3) orderID</SPAN></P> <P><SPAN>4) date field as logistic_date&nbsp;</SPAN></P> <P><SPAN>however i am able to count order ID using flag and able to plot it on weekly basis.</SPAN></P> <P><SPAN>kindly help me to figure out&nbsp;</SPAN></P> <P><SPAN>How should I calculate sum of&nbsp; quantity&nbsp; with different flag like delivered and dispatched on weekly and daily basis?</SPAN></P> <P>&nbsp;</P> Wed, 16 Nov 2022 13:23:00 GMT https://community.qlik.com/t5/QlikView/How-to-get-total-sum-of-different-quantity-products-for-each/m-p/2005306#M1221518 gary5 2022-11-16T13:23:00Z