Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
andreascarlos
Contributor II
Contributor II

dupplicate values by joining talbes

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

2 Replies
Lauri
Specialist
Specialist

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
Partner - Creator III
Partner - Creator III

use aggr function

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