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
