Discussion Board for collaboration related to QlikView App Development.
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 CURRENT ISSUANCE;
TIME_ID, //TIME ID Has no impact because its current issuance. we can delete time_id from here"
ITEM IN STOCK;
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
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
issue to wich division is "IT"
current item issue to employee_id "6123"
current issued qty to that employee is "2"
ITEM ISSUANCE HISTORY
time in which computer issued "600"
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"
time in which computer returm "605"
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