Qlik Community

Ask a Question

Connectivity & Data Prep

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

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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