topic Re: Sum is not getting same value fields in QlikView

Sum is not getting same value fields

Tue, 16 Apr 2013 21:10:06 GMT

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.

Re: Sum is not getting same value fields

Anonymous — Wed, 17 Apr 2013 01:53:04 GMT

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

Re: Sum is not getting same value fields

sreenivas — Wed, 17 Apr 2013 04:19:35 GMT

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