Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

synthetic key issue

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

0 Replies