Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Synthetic key problem

Hi QV community,

I have a synthetic key in my model as you can see in the image attached.I know that i can resolve it by buy connecting StockCode of StockSales table to StockSalesKey is a duplicate filed of StockCode in FilteredStockRequested. As FilteredStockRequested contains only a small subset of stock codes(40 codes) it is not a major waste of resources to have this duplicate key.StockSales and StockFreeStock contain full records of stock codes about 800 But I feel this in not the most efficient solution.Any other proposals???

I have attached the granularity of the related tables as well...


2 Replies
Not applicable

Re: Synthetic key problem


Pls Try Below...

Table 1

Table 2

StockCode  As  %StockCode

Table 3
StockCode As %StockCode

{Table 1 & Table 2 [Link Field StockCode ]

Table 2 & Table 3 [Link Field %StockCode ]}


Not applicable

Re: Synthetic key problem

That is exactlly what i did StockCode as StockSalesKey .....ast FilteredStocRequested....

Do you think this is the most efficient solution??