Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
maybe you know a solution for the problem...
I have two tables, which are joined. Lets say that there is fields: ProductID, PotentialSales, Sales, Shop
PotentialSales:
OfferID
ProductID
PotentialSales
RealSales:
OfferID
ProductID
Sales
ShopID
Now, after joining these two tables, I have situation, that when there is no productid in RealSales table, than there is no ShopID as well.
Example:
OfferID | ProductID | PotentialSales | Sales | ShopID |
---|---|---|---|---|
A1 | 111 | 500 | 200 | ABC |
A1 | 112 | 150 | ||
A1 | 113 | 200 | 100 | ABC |
A2 | 111 | 333 | ||
A2 | 113 | 554 | 410 | FBI |
OK, this is understandable, but I want to somehow copy ShopID to empty fields to calculate PotentialSales for all Shops?
Thank you in advance.
You should avoid having more than one column name being the key between two tables. Links between tables in QlikView should only be made using one (1) column. In your example you have the columns OfferID and ProductID in both tables and this will create a synthetic key.
Anyway, have you checked that you actually have data in your RealSales table for OfferID A1 in combination with ProductID 112?