Discussion Board for collaboration related to QlikView App Development.
seeing below example, is it possible to remove synthetic keys?
Create a key by combining the "GSK SKU ID" and "Distributor_Code" using Autonumber and use that to link btw DS2-Sales.xlsx and DS1-Stocks.xlsx
provide new key to connect between Sales and Stocks
[GSK_SKU_ID] & Distributor as %Key
from ... Sales.xlsx
[JDE_Code] & [Distr Code] as %Key
from .. Stocks.xlxs
Donot use as for JDE Code and Distr Code as otherwise new syntetic key will be created
or use qualify and unqualify for stocks
Keep [GSK SKU ID] and Distributor_Code in your sales table but Remove [JDE Code] and [Distr Code] from your another table...
Create a key in Sales and another table..
[GSK SKU ID] & '|' & Distributor_Code as Key
in another table
[JDE Code] & '|' &[Distr Code] as Key,
Have a look at this blog post:
Qlik Tips: Update to Link Table rules
One can not say that is it possible to remove the Synthetic key. One can easily rename them and remove it.
But the concept lies is your data model. Do it needs that
----You have do decide and control the linkings of these keys.
----Use composite keys to work on...
----Properly analyse the association of data your UI presentation and calculations need.