Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vinay_qlik
Contributor
Contributor

Cumulative Order Count based on 2 Dates driving by Single Date

Hi All,

I have 2 dates in my table and One Order ID.

Load Order ID,

     Shipment_Dt,

     Complete_Dt      /*With in the same Date as Shipment or future Date to the Shipment*/

from xyz.xlsx;

Business Rules:

1. Driving date on Dashboard - Shipment Dt.

2. I have to Display the counts based on Shipment DT and on Complete Dt as well. (2 Different KPIs)

1. Based on Shipment: (see the attached count) - Which is Straight Forward.

2. Based on Complete Dt: (See the attached Count) - Need help hand on this.

Requirement:

If I select Shipment Dt as  2018-Q2 on the Dashboard, then the Order Count in 2 KPI should show as 634.

Because it is the COUNT based on previous Shipment Dates till 2018-Q2.

Start Date is always 1/1/2017 in both the Shipment & Complete Dt.

Thanks in advance.

1 Reply
Anil_Babu_Samineni

Can you please share sample test file?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)