topic Synthetic key problem in QlikView

Synthetic key problem

Wed, 19 Jun 2013 09:57:21 GMT

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...

Regards,

Re: Synthetic key problem

Wed, 19 Jun 2013 10:20:59 GMT

Pls Try Below...

Table 1
StockCode

Table 2
StockCode,

StockCode As %StockCode

Table 3
StockCode As %StockCode

{Table 1 & Table 2 [Link Field StockCode ]

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

Regards-Bika

Re: Synthetic key problem

Wed, 19 Jun 2013 10:24:49 GMT

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

Do you think this is the most efficient solution??