I am joining 2 tables in editor load.
Excel Sheet Value
company: M120currency: EURuser: TIMpxcode: AAvalue: 100
and Excel Sheet Stati
company: M120currency: EURuser: TIMpxcode: AAstati: 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,
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.
use aggr function