Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!! 😩
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 };
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.
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.
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 };