Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
radupanciuc
New Contributor II

Average Lead Time Calculation

Hey guys,

I am trying to calculate the average lead time per customer. We want to calculate this at order level (so every order has the same weight) but orders have multiple lines (Items).

If I make a simple table at Order level, the lead time will be correct since Qlik Sense will calculate that at order level (Case 1). Unfortunately, if I want to look at customer level (Case 2), Qlik Sense will calculate based on the total order lines (Order No+Item) and therefore the average will not be correct (the same order will be taken into account multiple times).

Can you please give me a hint on how I can display the correct average lead time at customer level? For calculating lead time I am using the Networkdays function.

Case 1:

    

Order noDate SentDate ReceivedNetWorkDays
123.01.201727.01.20175.00
223.01.201726.01.20174.00
323.01.201727.01.20175.00
420.01.201725.01.20174.00
520.01.201725.01.20174.00
Average Lead Time4.40

Case 2:

     

Order noItemDate SentDate ReceivedNetWorkDays
11023.01.201727.01.20175.00
12023.01.201727.01.20175.00
13023.01.201727.01.20175.00
21023.01.201726.01.20174.00
31023.01.201727.01.20175.00
41020.01.201725.01.20174.00
51020.01.201725.01.20174.00
Average

4.57

1 Reply

Re: Average Lead Time Calculation

May be this

Avg(Aggr(NetWorkDays([Date Sent], [Date Received]), [Order no]))