Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
In Your Datamodelling There is Synthetic Keys ,I have eliminated those PFA of the updated file.
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
Hi
In Your Datamodelling There is Synthetic Keys ,I have eliminated those PFA of the updated file.