I have a tricky issue with trying to cross reference a main data source with a special selection. To help explain this I have mocked up an example qvw.
There are two tables, firstly the MAIN data table has an id, a date and a value. The second is a SELECTION table which has an ID, start and end date ranges along with a "product code".
I would like to cross reference the MAIN with a "selection" table so that for each ID I would be able to filter the main data source to only show the specific product code that has been selected. So in this example if I selected TUO1 I would see ID 1 for ranges 04/02/2010 - 06/02/2012 and ID 2 for 02/02/2010 - 06/02/2012
The way that has been tried in the example is a left join, and then I would use the date ranges to create a filter. The only issue is that the left join creates duplicate fields for all the TEST.VALUE values.
Hopefully I have explained it correctly. If you need any further information please let me know.