sum with different results - PivotTbl vs Table

[Anonymous]

Dear all,

i have a really tricky Problem. Somehow the aggregation of my data in a pivot table is not working properly.

I've made a screenshot:

In the table the sum is ca 48 and in the pivot its doubled? (P.S: in the Combi Diagramm its also wrong)

Any idea?

cheers chesterluck

[Anonymous]

well, I don't think that it is the join (anyway I will test it). I think it is connected to the 3rd load (resident load).

See, im doing first a left join and then, in order to perform an if statement with data from both tables, I'm doing the resident load. I don't know whether it is the correct way...

P.S.: i found here sth., maybe it leads to the solution:

http://community.qlik.com/message/159983#159983

[Anonymous]

Issue solved. It was a join on a later stage. Thx for the support