AOA
I have loading qlikview from datawarehouse....
which has 4 fact table
1) ITEM PURCHASE
2) ITEM CURRENT_ISSUANCE
3) ITEM ISSUANCE_HISTORY
4) ITEM RETURN_HISTORY
5) ITEM IN STOCK
ITEM PURCHASE;
LOAD
SUPPLIER_ID
TIME_ID,
PART_NO,
PURCHASE_TYPE_ID,
STOCKIST_ID,
PURCHASED_QTY
PURCHASED_COST
FROM
(QVD);
ITEM CURRENT ISSUANCE;
LOAD
DIVISION_CODE,
EMPLOYEE_ID,
TIME_ID, //TIME ID Has no impact because its current issuance. we can delete time_id from here"
PART_NO,
STOCKIST_ID,
CURRENT_ISSUE_QTY
FROM
(QVD);
ITEM ISSUANCE_HISTORY;
LOAD
DIVISION_CODE,
EMPLOYEE_ID,
TIME_ID,
PART_NO,
STOCKIST_ID,
ISSUE_QTY
FROM
(QVD);
ITEM_RETURN_HISTORY;
LOAD
DIVISION_CODE,
EMPLOYEE_ID,
TIME_ID,
PART_NO,
STOCKIST_ID,
RETURN_QTY
FROM
(QVD);
ITEM IN STOCK;
load
LOCATION_ID
PART_NO,
STOCKIST_ID,
STORE_ID,
INSTOCK_QTY
FROM
(QVD);
when i show data in stright/pivot table on pushase sheet its show correct figures mean no issue with ITEM PURCHASE.
but on issue and stock sheet only those data is displaying which is availble in these 3 table. ITEM ISSUANCE_HISTORY, ITEM RETURN_HISTORY
and ITEM IN STOCK
note: when i comment these two laoding TABLES and reload then correct data show in stock sheet
ITEM ISSUANCE_HISTORY
ITEM RETURN_HISTORY
any advice???
(e.g suppose
I have purchased"computers" so as per our records for ITEM PURCHASE is
partno of computer is 111111
stock who order computer is"IT STOCK"
purchasing type is "ORDER"
purchase on time_id is 599
purchase from supplier_id is 45
purchase_qty is 10 unit
purchase_cost is 100000 unit
ITEM CURRENT_ISSUANCE
issue to wich division is "IT"
partno of computer is 111111
stock who order computer is"IT STOCK"
current item issue to employee_id "6123"
current issued qty to that employee is "2"
ITEM ISSUANCE HISTORY
issue to wich division is "IT"
partno of computer is 111111
time in which computer issued "600"
stock who order computer is"IT STOCK"
employee_id to whom computer issue is "6123"
item issue so far is ISSUE_QTY="3"
ITEM RETURN HISTORY
recived from to wich division is "IT"
partno of computer is 111111
time in which computer returm "605"
stock who order computer is"IT STOCK"
employee_id to whom computer issue is "6123"
item issue so far is RETURN_QTY="1"
ITEM IN STOCK
item is at location"a"
stock having item in sotck is "IT STOCK"
store under sotck is "IT HARDWARE"
partno is 111111
qty present in stock is 8
as u can se record present in 3 of above table so it will display record in stock sheet.....
if let say employee has not return any item yet so no record availbe in ITEM RETURN HISTORY
so no record also found in stock sheet)
hope u understnd the senerio
