topic Re: Get a value from a disconnected table in QlikView

Get a value from a disconnected table

Wed, 03 Feb 2016 18:11:56 GMT

Hi, I have two tables like these:

Costs:

LOAD * Inline [

Name,Cost,CostDate

AAA,343,23/07/2014

BBB,565,31/08/2015

CCC,775,06/04/2011

DDD,453,01/11/2015

EEE,543,08/12/2009

AAA,565,11/02/2013

BBB,932,15/07/2012

CCC,454,28/05/2010

];

IVA:

LOAD * Inline [

Percentage,StartDate,EndDate

16,01/01/1995,30/06/2010

18,01/07/2010,31/08/2012

21,01/09/2012,31/12/9999

];

How could I create a table like this?:

What expression could I use in the last column?

Thanks in advance

Wed, 03 Feb 2016 18:38:26 GMT

You can use IntervalMatch to join the date intervals.

Wed, 03 Feb 2016 18:39:17 GMT

Check below post as reference.

Gysbert_Wassenaar — Wed, 03 Feb 2016 18:49:17 GMT

You can use the IntervalMatch function. See this blog post: IntervalMatch