Different SQL results in qlikview

zhadrakas — Thu, 28 Apr 2016 09:24:08 GMT

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?

Re: Different SQL results in qlikview

awhitfield — Thu, 28 Apr 2016 15:25:23 GMT

Hi Tim,

what's in the load part of the script? You have only post the SQl select.

Adny

Re: Different SQL results in qlikview

zhadrakas — Tue, 03 May 2016 04:46:33 GMT

here is my qvw. i have only removed the Connection strings.

topic Different SQL results in qlikview in QlikView

Different SQL results in qlikview

Re: Different SQL results in qlikview

Re: Different SQL results in qlikview