Problem with IntervalMatch

Wed, 15 Apr 2015 16:23:02 GMT

Hello,

I'm using the IntervalMatch function to filter within a range of dates for a given date.

What I do is this:

QV_UNIDAD_PROGRAMA:

LOAD

COD_UP,

COD_TEC,

COD_SUBTEC,

PT_MAX,

FEC_INI_VIG as FIV_UP,

FEC_FIN_VIG as FFV_UP

FROM [$ (vpath) QV_UNIDAD_PROGRAMA.qvd] (qvd);

CalendarRes:

LOAD

AddedDate as Date,

Time (Frac (AddedTimeStamp), 'hh') & ': 00' as Time,

Num (Time (Frac (AddedTimeStamp), 'h') & '') + 1 as Period

RESIDENT TempCalendar;

Here the correct loads.

Union:

IntervalMatch (Date)

load distinct

FIV_UP,

FFV_UP

QV_UNIDAD_PROGRAMA resident;

But when we perform IntervalMatch, it generates the following:

And what I want to know is how Syn1 off the table?

Can anybody help me?

Thank you very much in advance.

A greeting.

Re: Problem with IntervalMatch

Aurelien_Martinez — Fri, 17 Apr 2015 15:53:17 GMT

Hi,

//After this

Union:

IntervalMatch (Date)

load distinct

FIV_UP,

FFV_UP

QV_UNIDAD_PROGRAMA resident;

//Use

Left join(QV_UNIDAD_PROGRAMA)

Load

residente Union

;

drop table Union;

Re: Problem with IntervalMatch

Mon, 20 Apr 2015 08:04:01 GMT

thanks so much, worked perfectly

topic Problem with IntervalMatch in QlikView

Problem with IntervalMatch

Re: Problem with IntervalMatch

Re: Problem with IntervalMatch