Double Qty Persists

[oseimuduame]

Good Afternoon,

i had an issue some months Back and i got a response.

The issue is that i was experiencing Double Qty some times back and i used DISTINCT to correct this and it worked for sometime only for me to realize now that there are still some occurences of the Duplicate item qty.

Please any idea on how to resolve this.

//inventory qty

SQL SELECT DISTINCT

  TO_CHAR(q.ITEM_SID) AS "ITEM_SID",

  q.SBS_NO AS "SBS_NO",

  q.STORE_NO AS "STORE_NO",

  q.QTY as "OH_QTY",

  q.MIN_QTY as "MIN_QTY",

  q.MAX_QTY as "MAX_QTY",

   q.TRANSFER_IN_QTY as "TRANS_IN",

  q.TRANSFER_OUT_QTY as "TRANS_OUT",

  (n.COST * q.QTY) AS "EXT_COST"

FROM INVN_SBS_QTY q

INNER JOIN INVN_SBS n ON n.ITEM_SID = q.ITEM_SID

WHERE q.STORE_NO < 250 AND q.SBS_NO in $(subsidiaries);

Thank You.

[qv_testing]

No, This is SQL script.

You have to convert Qlikview level.

See  below....

INVN_SBS_QTY:

SQL SELECT

  TO_CHAR(q.ITEM_SID) AS "ITEM_SID",

  SBS_NO AS "SBS_NO",

  STORE_NO AS "STORE_NO",

  QTY as "OH_QTY",

  MIN_QTY as "MIN_QTY",

  MAX_QTY as "MAX_QTY",

  TRANSFER_IN_QTY as "TRANS_IN",

  TRANSFER_OUT_QTY as "TRANS_OUT",

  QTY AS Qty      // Quantity in INVN_SBS_QTY

FROM INVN_SBS_QTY

WHERE STORE_NO < 250 AND SBS_NO in $(subsidiaries);

Store INVN_SBS_QTY into path/INVN_SBS_QTY .qvd(qvd);

INVN_SBS:

SQL SELECT

  ITEM_SID

  COST AS COST    // Cost in INVN_SBS

FROM INVN_SBS;

Store INVN_SBS into path/INVN_SBS.qvd(qvd);

Create like 2 separate QVD's INVN_SBS_QTY and INVN_SBS;

then use like below...

Load 

  ITEM_SID,

  SBS_NO,

  STORE_NO,

  OH_QTY,

  MIN_QTY,

  MAX_QTY,

  TRANS_IN,

  TRANS_OUT,

  QTY

From  INVN_SBS_QTY ;

left Keep

Load

  ITEM_SID

  COST

FROM INVN_SBS;

This should work...:)