Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys, I'm a brand new QlikView user, so I thank you in advance for your help.
I'm trying to select all items (PN field) from the table POD and their matches into the tables REC and BOM, in order to show in the report the PNs, the date the items where requested (NEED DATE in BOM) and the date they where received (RECEIVING_DATE in REC). The problem is the Select is just showing once when there are repeated PNs into POD. It is probably basic, but I cannot find where the error is.
Here is the selects I'm using:
POD:
SQL SELECT
POH_AUTO_KEY,
POD_AUTO_KEY,
NEXT_DELIVERY_DATE,
POH_AUTO_KEY||'-'||PNM_AUTO_KEY as PN_KEY
FROM QCTL."PO_DETAIL";
REC:
SQL SELECT
"ENTRY_DATE" AS RECEIVING_DATE,
"POD_AUTO_KEY"
FROM QCTL."RC_DETAIL";
BOM:
SQL SELECT
PNM_AUTO_KEY,
ENTRY_DATE AS ITEM_DATE,
NEED_DATE,
ACTIVITY,
SI_NUMBER,
POH_AUTO_KEY||'-'||PNM_AUTO_KEY AS PN_KEY
FROM QCTL."VIEW_WOBOM"
;
Thank you again.
Marineusa
Try this:
POD:
SQL SELECT
POH_AUTO_KEY,
POD_AUTO_KEY,
NEXT_DELIVERY_DATE,
POH_AUTO_KEY||'-'||PNM_AUTO_KEY as PN_KEY
FROM QCTL."PO_DETAIL";
REC:
Load *
where exists(POD_AUTO_KEY);
SQL SELECT
ENTRY_DATE AS RECEIVING_DATE,
POD_AUTO_KEY
FROM QCTL."RC_DETAIL";
BOM:
Load *
where exists(PN_KEY);
SQL SELECT
PNM_AUTO_KEY,
ENTRY_DATE AS ITEM_DATE,
NEED_DATE,
ACTIVITY,
SI_NUMBER,
POH_AUTO_KEY||'-'||PNM_AUTO_KEY AS PN_KEY
FROM QCTL."VIEW_WOBOM"
;