dupplicate values by joining talbes

[andreascarlos]

Hi Community. 

I am joining 2 tables in editor load.

Excel Sheet Value

company: M120
currency: EUR
user: TIM
pxcode: AA
value: 100

and Excel Sheet Stati

company: M120
currency: EUR
user: TIM
pxcode: AA
stati: 365 , 654, 951, 673, 845 

As I have 5 different records in attribut "stati" for each record  of(company=M120, currency=EUR, user=TIM and pxcode=AA) the values for "Value" are dupplicated by 5. (See qvf file).

So as restult Sense return sum(value) = 500 when it should be 100.
How can I solve the issue?
Thanks and regards,

Carlos

[Lauri]

I would not join the two tables. Load them as separate tables. Qlik will create a synthetic key on the 4 fields with the same name.

[florentina_doga]

use aggr function

sum(aagr(value,company,currency,user,pxcod))