Discussion Board for collaboration on QlikView Scripting.
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:
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?
what's in the load part of the script? You have only post the SQl select.
here is my qvw. i have only removed the Connection strings.