Data load from Oracle databese- not all data got through to Qlik

Bernardvanecek — Mon, 13 Dec 2021 17:37:52 GMT

Hi there,

having a problem with viewing correct data in Qlik after loading them from Oracle database.

When I load my test script:

SELECT 'Test data' as POS_STAGE,
TO_NUMBER(COUNT(CASE WHEN APPL_DATE>=(TRUNC(SYSDATE,'DD')-14-ROUND(
TO_CHAR(SYSDATE-1, 'D'),0)) AND APPL_DATE<(TRUNC(SYSDATE,'DD')-7-ROUND(
TO_CHAR(SYSDATE-1, 'D'),0))
THEN APPL_DATE WHEN APPL_DATE>=(TRUNC(SYSDATE,'DD')-14-ROUND(
TO_CHAR(SYSDATE-1, 'D'),0)) AND APPL_DATE<(TRUNC(SYSDATE,'DD')-7-ROUND(
TO_CHAR(SYSDATE-1, 'D'),0))
THEN APPL_DATE ELSE NULL END)) TWOWEEKSAGO

FROM .....

I can see correct count of appl_date -> 97
But when I reload the same script in Qlik it shows me only 94.

I am using Qlik version April 2019 and being from Czech republic I guess there may be some discrepancies via date and time formats which I have tried to eliminate setting up to standard Europe formats including FirstWeekDay=0.

Anyway still having this problem and I am stuck in a dead end.

Any ideas how to fix this problem?

Bernard

topic Data load from Oracle databese- not all data got through to Qlik in Connectivity & Data Prep

Data load from Oracle databese- not all data got through to Qlik