Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

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

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.