Combine multiple trips flag (milkrun) issue

ahmed_zeidan — Wed, 25 Nov 2020 16:16:04 GMT

Dear Qlikview community, i am new to Qlickview and i am working on logistics project , where i am facing the following issue:

I have following scenario : i have multiple delivery orders are combined into the same trip with the dispatch tool (trip will be milk run ) , i.e. multiple stops , the dispatch tool will give the following information , the information will look like something like below:

Delivery Order Number Trip ID KM Driven Product Quantity Delivered Customer Name Driver

234324234 5464353 100 5 Ton Customer A Driver A

234234523 5464353 100 3 Ton Customer A Driver A

234323421 5464353 120 8 Ton Customer B Driver A

234343321 5464353 140 10 Ton Customer C Driver A

394234232 5332321 160 20 Ton Customer D Driver D

Now : I would like to calculate the following :

1) when i calculate the total distance driven in single day , the distance will be 140 KM + 160 KM as first 4 orders in the same 5464353 ,

2) when i calculate the total km driven per driver , then it should look like ( Driver A : 140 KM / Driver D : 160 KM )

3) i would like to have flag which can show those duplicated trips or key as i am still required to allow the user to view this information

Expected outcome:

Total Distance : 300 KM

Total Distance Driver A : 140 KM

Total Distance Driver B : 160 KM

topic Combine multiple trips flag (milkrun) issue in QlikView

Combine multiple trips flag (milkrun) issue