2 Replies Latest reply: May 3, 2016 12:46 AM by Tim Driller RSS

    Different SQL results in qlikview

    Tim Driller

      Hello all,

       

      i have the following SQL in QlikView.

       

      SQL SELECT
      int(N.QSOART) as DAN
      int(AZP2AR) as ref_DAN
      FROM
      DATEIEN.ARLAZUP N
      INNER JOIN DATEIEN.ARZUSP ON N.QSOART = AZSOAR
      where N.QSOART in (555807, … ,472968);

       

      I have experienced different results of this SQL in Qlikview and my DB-Viewer (DB-Visualizer). So I began testing

       

      MY SOURCE DATA:

       

       

      TESTING:

       

       

      Tested in DB-Visualizer with JDBC driver:
      -> should be null but that’s not the big deal

       

      Tested in DB-Visualizer with ODBC driver:

       

      -> works correct

       

      Tested in QlikView with JDBC driver:

       

      -> should be null but that’s not the big deal

       

      Tested in QlikView with ODBC driver:

       

      -> definitely works wrong.

       

      This problem occurs if the Source Data int(AZP2AR)is a NULL value.

       

      My question: How does Qlikview get this REF_DAN_01?