[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,

[alexandros17]

I do not think there is any bug, check better data,

I see that you have done a group by while in qlik view there is a simple sum ?

Let me know

[MK_QSL]

Can you load your data in excel file please?

[#4]

Hello,

Well, I have add "annee" as a Dimension. So I consider that it implies "annee" as a part of the group by.

I don't know if you have noticed but for 2008, numbers are good... but not for the others.

[MK_QSL]

Kindly load your sample data in excel format.. thanks

[alexandros17]

You're right there should not be differences between the 2 results but if therere are it means there is something wrong with data:

The first question is:

LOAD annee,

    "nb_jours_realise";

SQL SELECT *

FROM palan."public"."v_projet_charges_agent";

why have you used " for the field nb_jours_realise?

Could you attach an example?

[#7]

Well, I haven't use quotes ", QlikView put it automatically because the field name contains underscores.

[#8]

I am sending it (in CSV and Excel format).

Thanks,

[alexandros17]

try to load without quotes, verify (with a simple table - so no dimensions and expression) that numbers are aligned to the right (this means that qlikview recognise data as numeric)

Let me know

[MK_QSL]

This is what I received in QlikView when I load your excel file...