Hi, I am fairly new to Qlikview and hope somebody can help me. Below is a example of my spreadsheet of vehicle registration and the mileage it has done for the month. The vehicle is put against a cost centre - which i want it to pull the cost from. However sometimes it gets billed to the incorrect cost centre. How can I force Qlikview to keep the cost centre that is belongs to and ignore the cost centre that it was billed to. I Hope that makes sense and thank you in advance for your help.
Use different filed names for Original Cost Center and Billed Cost Center - if you use the same names, Qlik will most likely pull data of both sorts. Make sure you use the Orig Cost Center column in your report.
I am doing a Cost per Kilometer report - so I have the mileage and it will pull cost relating to the vehicle from our accounting package. The problem I encounter is the Customer allocates the vehicle to a certain cost centre, however sometimes people bill cost to the incorrect cost centre. So what I am finding is if I don't put the cost centre that it was billed to it is not picking up the cost - and therefore having to have two entries of the vehicle registration sitting in two different cost centres. In below example - how can I force qlikview to push the cost and mileage (even though billed incorrectly) to Linehaul. I hope that makes sense - I am sorry if I can't explain it better.