topic Re: dupplicate values by joining talbes in App Development

dupplicate values by joining talbes

andreascarlos — Tue, 29 Oct 2019 09:48:28 GMT

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

Re: dupplicate values by joining talbes

Lauri — Tue, 29 Oct 2019 12:59:51 GMT

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.

Re: dupplicate values by joining talbes

florentina_doga — Tue, 29 Oct 2019 13:13:04 GMT

use aggr function

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