Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
gary5
Contributor
Contributor

How to get total sum of different quantity products for each distinct order? with condition like delivered, dispatched for daily and weekly basis

My in my case one Item assigned with OrderID may  have quantity more than 1. For example one item with 2 quantity has been ordered

My fields are 

1) date flag which have delivered and dispatched

2) Quantity 

3) orderID

4) date field as logistic_date 

however i am able to count order ID using flag and able to plot it on weekly basis.

kindly help me to figure out 

How should I calculate sum of  quantity  with different flag like delivered and dispatched on weekly and daily basis?

 

0 Replies