Creating a cross reference

paulm — Thu, 05 Jul 2012 17:31:45 GMT

Hi,

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.

Any help would be greatly appreciated

Paul

Re: Creating a cross reference

swuehl — Thu, 05 Jul 2012 18:35:02 GMT

I think there are multiple ways to achieve your expected result, for example, you can try using an INTERVALMATCH.

See attached.

Hope this helps,

Stefan

Re: Creating a cross reference

MayilVahanan — Thu, 05 Jul 2012 18:36:52 GMT

Hi,

See the attached file..

Hope it helps..

Re: Creating a cross reference

paulm — Wed, 11 Jul 2012 14:48:27 GMT

Hi Guys,

Thanks for the help with this. It worked perfectly.

Paul

topic Re: Creating a cross reference in QlikView

Creating a cross reference

Re: Creating a cross reference

Re: Creating a cross reference

Re: Creating a cross reference