New user to Qlikview

[Anonymous]

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

[MarcoWedel]

please post your expected result as well (based on your sample data).

[Anonymous]

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.

[balabhaskarqlik]

First check that, is the data mismatch happening in Qlikview or it's data issue. Then verify the Billed Cost center data.

[Anonymous]

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

[qlikviewwizard]

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;