How to fill empty fields based on values stored in joined table?

Mon, 07 Dec 2015 10:12:05 GMT

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.

Re: How to fill empty fields based on values stored in joined table?

henrikalmen — Wed, 16 Dec 2015 14:59:55 GMT

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?

topic Re: How to fill empty fields based on values stored in joined table? in QlikView

How to fill empty fields based on values stored in joined table?

Re: How to fill empty fields based on values stored in joined table?