Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

zhadrakas
Valued Contributor

Different SQL results in qlikview

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?

 

Tags (2)
2 Replies
awhitfield
Esteemed Contributor

Re: Different SQL results in qlikview

Hi Tim,

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

Adny

zhadrakas
Valued Contributor

Re: Different SQL results in qlikview

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

Community Browser