Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
REGO | COST CENTRE | Jun-17 | Jul-17 | Aug-17 | Sep-17 |
ABC123 | LINEHAUL | 42154 | 42154 | 42154 | 42154 |
DEF567 | SHORTHAUL | 3200 | 3200 | 3200 | 3200 |
GHI456 | INTER-ISLAND | 56666 | 56666 | 56666 | 56666 |
Thanks
Fiona
please post your expected result as well (based on your sample data).
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.
Hope this helps.
First check that, is the data mismatch happening in Qlikview or it's data issue. Then verify the Billed Cost center data.
Hi Marco
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.
Rego Cost Centre June-17 July-17 Aug-17
ABC123 Linehaul 42154 42154
ABC123 Shorthaul 42154 42154
Thank you
Fiona
Hi,
Try like this.
Data_Temp:
CrossTable(Month_Temp, Data, 2)
LOAD *
FROM
[308494.xlsx]
(ooxml, embedded labels, table is Sheet1);
NoConcatenate
Data:
LOAD *,DATE(num#(Month_Temp),'MMM-YY') as Month Resident Data_Temp;
DROP TABLE Data_Temp;