topic Sum() issue in App Development

Sum() issue

danimarc12 — Sun, 11 Dec 2022 16:54:44 GMT

Hello guys,

I have a big issue with my app.

I can't understand why QlikSense changes some values.

as you can see, if I add in my table Netto as a dimension I see the correct values, if I sum these values, on the second row, it display the value x2. (?!?!) I've checked also in the db and there are no differences:

I have really no idea what's going on.

Obviously the Sum(Netto) in my DB is correct:

Did anyone have the same problem? Do you know why it can happens and how to fix it?

This is one example, there are a lot!

Thanks to all!! 😩

Re: Sum() issue

BrunPierre — Sun, 11 Dec 2022 18:43:31 GMT

This may indicate that the data contains a duplicate row. Place all of the table's fields inside the table box to identify which ones cause duplication.

Re: Sum() issue

danimarc12 — Mon, 19 Dec 2022 18:08:30 GMT

Hi @BrunPierre ,

thanks a lot for your indication! I've found my error but I don't know how to fix it.

Basically it is here:

If I comment this JOIN everything is working good. My fact table is Scarico and I need the information of serie which is an attribute of CodArtFor.

Maybe the Join is wrong.

Re: Sum() issue

BrunPierre — Mon, 19 Dec 2022 20:21:24 GMT

To avoid duplication in the fact table, use Mapping Load, a technique similar to a left join but fundamentally different. A mapping load, on the other hand, ensures that only one of the ID records actually maps into the receiving table.