Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show Data on Chart prior to certain date

I have extracted two sets of data, the fist one shows sales order requirements, the green/red column indicates where we run out of finished stock.

6G33-L611B11-BE28/03/2011 00:00:00141456
6G33-L611B11-BE04/04/2011 00:00:0072156
6G33-L611B11-BE11/04/2011 00:00:00143556
6G33-L611B11-BE09/05/2011 00:00:00215656
6G33-L611B11-BE16/05/2011 00:00:00217756
6G33-L611B11-BE13/06/2011 00:00:004211956
6G33-L611B11-BE11/07/2011 00:00:002114056
6G33-L611B11-BE15/08/2012 00:00:00714756

The second table show internal works orders to replenish stock.

6G33-L611B11-BEWO-06717713/08/2010 00:00:0088
6G33-L611B11-BEWO-06764318/04/2011 00:00:007280

what I would like to show is sum of column 4 in table two as a column in table one where the date in table two is less than date in table one.

So the first three rows on table one would show 8, and the fourth row would show 80, further rows would show 0.

Is this possible?

0 Replies