Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Bernardvanecek
Contributor
Contributor

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

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

 

Labels (3)
0 Replies