0 Replies Latest reply: Aug 17, 2017 7:03 AM by abhishek shukla RSS

    Oracle query working in DB but fetching 0 rows in Qlik Sense Data load editor

    abhishek shukla

      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.