Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
satish25
Contributor III
Contributor III

values are multiplied..

I have 2 tables with a common key. When I link these 2 tables (On common field, Not join), the values are shown correctly. However when I join these 2 tables (irrespective of the joins used), the values are multiplied..

 

 

common key is 

Business_Year&'_'&Business_Month As YearMonthKey      -------    Sheet A

B_Year&'_'&B_Name As YearMonthKey      -------    Sheet B

 

 

Output :

op : Sum(Fin_Amt) where Fin_Charge=EDC Charges  = 751273 (Calculation in Data Load Editor Only )

YearMonthKey     StoreID Sum(op)
Labels (3)
6 Replies
yogiachilleos
Contributor III
Contributor III

Howdy Satish25,

You mention the values are multiplied, are you seeing these multiplied values in a table/chart? Or in the datamodel previewer?

Kind regards,
Yogi Achilleos
satish25
Contributor III
Contributor III
Author

In straight table

Channa
Specialist III
Specialist III

if you using same number straight table link or join dosent bring any difference

when you link may be it has another common field(synthetic key)

 

 

Channa
satish25
Contributor III
Contributor III
Author

hi channa,

it dosent have any other common field(synthetic key).

i have data from data source as given in attached excel file.

sajalgour2309
Contributor II
Contributor II

of course it will not give you 3912.88 if you join it because both of your tables on different granularity. In one table you have storeid now if you will join fin amount will be repeated against all storeids which will give you 3912.88 * (number of storeid) = 751273 

Sajal

FruzoCrew
Creator
Creator

Yes, because B table has the same name and year (April, 2019) six times.

And each line (April, 2019 from table B)will create separate lines for each line having the same value(April, 2019) in table A.

 

Count of B table lines having April, 2019 : 192

EDC Charges = 3912.88

Sum(Fin_Amt) where Fin_Charge=EDC Charges=3912.88*192 = 751272.96