Missing data

Thu, 07 Mar 2013 10:05:13 GMT

If I have a table with the following information

Invoice Date	Invoice No	Stock Code	Sell Price	Cost Price
01/01/2012	INV01	STK1	100	35
01/02/2012	INV02	STK1	100	35
01/03/2012	INV03	STK1	100	35
01/04/2012	INV04	STK1	100	35
01/05/2012	INV05	STK1	100	35

And I have another table with the following info

Date	Stock Code	Hidden Cost
01/01/2012	STK1	45
14/03/2012	STK1	50

If I wanted to create a chart with the following columns

Invoice Date, Invoice Number, Stock Code, Margin, Hidden Margin

The margin is the difference between Sell and Cost Prices

The hidden margin is the difference between the Sell and Hidden Costs.

I am guessing I would I need to generate a record in the second table for everyday of the year, and then I can link the invoice date and stock item to this data.

Can someone please explain how to do this, or point me at a resource that explains how to generate the data.

Thanks

Andy

Re: Missing data

Gysbert_Wassenaar — Thu, 07 Mar 2013 10:10:12 GMT

You're right. See this blog post for how to do that.

Re: Missing data

Tue, 16 Apr 2013 07:26:28 GMT

Thank you for the help Gysbert.

I am actually going to be looking at this today as the customer has ordered the work

topic Re: Missing data in QlikView

Missing data

Re: Missing data

Re: Missing data