Select not showing all data

Wed, 13 May 2015 13:34:01 GMT

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

Re: Select not showing all data

Fri, 15 May 2015 08:33:26 GMT

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"
;

topic Re: Select not showing all data in QlikView

Select not showing all data

Re: Select not showing all data