[Bug] Bug with set analysis

[#1]

Hello,

I think i have a bug with Qlikview when I am using sum().

Here a simple test with the DBMS :

Here the results with QlikView :

The source is the same DBMS.

Here is my script :

SET ThousandSep=' ';

SET DecimalSep=',';

SET MoneyThousandSep=' ';

SET MoneyDecimalSep=',';

SET MoneyFormat='# ##0,00 €;-# ##0,00 €';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';

SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

OLEDB CONNECT32 TO secret_chain;

LOAD annee,

    "nb_jours_realise";

SQL SELECT *

FROM palan."public"."v_projet_charges_agent";

Here is the set analysis I use : sum(nb_jours_realise)

Is there any cache to empty ? Should I reinstall QlikView ?

Thanks,

[#2]

I have reloaded the first request without quotes -> same result as before.

I have created a new simple table, without any dimension or expression -> does not show any data (there is only a grey rectangle).

I have create a new second simple table, with "annee" and "nb_jours_realise" as dimension -> I can see columns names, but the table is empty.

[alexandros17 · Accepted solution]

I'm trying to do an analysis:

1) When I load data from excel it seem all correct

2) settings are correct

The only difference is that you load data from an sql:

1) first try to load from excel and verify the result. if it is correct (as I think) the only problem could be the OLEDB CONNECT32 TO secret_chain; try with ODBC

Let me know

[#4]

Yes you were right ! The results are correct when I use ODBC instead of OLEDB.

But can you explain where those differences are comming from ?

Thanks

[alexandros17]

Probably because the Oledb driver is not the correct one!