Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum is not getting same value fields

I have 2 tables, TABLE1 and TABLE2.
TABLE1 has columns ACCNO, descr and VALUE

TABLE 2 has columns ACCNO, descr, SEQ and VALUE.

In the image you can see both tables that I reloaded with different names to not tie up the data.

Problem is, when I tie those tables with ACCNO and descr columns, the sum only gets the different values, which you can see in the image.

The RECVD value on the upper left table is 150 and should be 300 ?

Any ideas ?

Attached are test.qvw and excel files.

Untitled.jpg

1 Solution

Accepted Solutions
sreenivas
Creator III
Creator III

Hi

In Your Datamodelling There is Synthetic Keys ,I have eliminated those PFA of the updated file.

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi Rafael,

I think the confusion about the results that you're experiencing is due to the synthetic key in your data model.

Here's a blog entry from Henric Cronstrom about synthetic keys and how they work. Searching the forums should also provide quite a few hits on how to change this:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys

sreenivas
Creator III
Creator III

Hi

In Your Datamodelling There is Synthetic Keys ,I have eliminated those PFA of the updated file.