Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
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.