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