Hi ,
This is second time i am asking a question , hoping to get answers this time.
I have an oracle query which is working fine in Oracle DB but fetching 0 rows in Qlik , please help me out with this.
following is the query.
SELECT RDC.CONSTRAINTID,
dt.period_Date RFS_PROD_WEEK,
COUNT(DISTINCT RFS.ORDERKEY) MN_TOT_ORD_COUNT_WK
FROM opqrstuv.rstuvwx_D_CONSTRAINT RDC JOIN
OPQRSTUV.RSTUVWX_F_SCHEDULE RFS JOIN
OPQRSTUV.UDT_CG_FGHIJKLMNOP GFO JOIN
opqrstuv.rstuvwx_MISC_CONS_opqrstuv_REL MISC JOIN
(SELECT YEAR_DATE, PERIOD_DATE FROM opqrstuv.mdt_date_info
) DT
WHERE RFS.MODELID IN
( SELECT DISTINCT MODELID
FROM opqrstuv.MDT_PK_Mnopqrst
WHERE PK_ID IN
( SELECT DISTINCT pk_id FROM mdt_pk WHERE active = 'true'
)
AND PK_LEVEL= 'WSL'
)
AND RFS.SCENARIOID = 1
AND RDC.CONSTRAINTID IN
(SELECT DISTINCT(constraintid) FROM rstuvwx_D_CONSTRAINT
)
AND RFS.PRODUCTIONDATE>=TRUNC(SYSDATE)
AND RFS.FACTORYORDERID =GFO.FACTORYORDERID
AND RDC.MODELID =RFS.MODELID
AND RDC.MODELID =MISC.MODELID
AND RDC.SCENARIOID =RFS.SCENARIOID
AND RDC.SCENARIOID =MISC.SCENARIOID
AND MISC.ORDERKEY =RFS.ORDERKEY
AND MISC.CONSTRAINTKEY =RDC.ROWKEY
AND DT.YEAR_DATE =RFS.PRODUCTIONDATE
GROUP BY RDC.CONSTRAINTID,
dt.period_Date;
Looking forward for your kind response.
