Sum() issue

[danimarc12]

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!! 😩

[BrunPierre]

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.

[danimarc12]

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.

[BrunPierre · Accepted solution]

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.

More from here: Mapping 

However, you can attempt this.

Map_Serie:
Mapping LOAD codperfor as CodperFor,
             Serie
FROM 
[lib://Garden House:DataFiles/mag_serie.qvd](qvd); 

Scarico:
LOAD *,
ApplyMap('Map_Serie', CodperFor) as Serie

FROM { Data Sources };