topic Interval match in QlikView

Interval match

samuel_brierley — Mon, 02 Sep 2013 10:45:24 GMT

Can anybody advise where im going wrong with this?

load

[Date Detected],
[Date Cleared]
FROM
[blah blah blah]
(ooxml, embedded labels, table is Halogen);
load [Interval Date]
from

[Blah blah blah]
(ooxml, embedded labels, table is Date);
IntervalMatch ([Interval Date])

load Distinct [Date Detected],[Date Cleared]resident Halogen

the interval date is juts a column of days, one row for each day.

date detected and date cleared are self explanatory.

by looking at the table the interval IS NOT between the fault detected and fault cleared as it should be.

NOTE: the collumns A-C are completely unrelated to this

vikasmahajan — Mon, 02 Sep 2013 10:50:48 GMT

PFA

samuel_brierley — Mon, 02 Sep 2013 10:54:17 GMT

sorry i only have the trial I cant open them

Mon, 02 Sep 2013 11:08:53 GMT

Dear

Try it will work.

load

Key,

[Date Detected],

[Date Cleared]

FROM

[blah blah blah]

(ooxml, embedded labels, table is Halogen);

load Key, [Interval Date]

from

[Blah blah blah]

(ooxml, embedded labels, table is Date);

JOIN

IntervalMatch([Interval Date],Key)

load [Date Detected], [Date Cleared],Key resident A;

Here Key means primary key by which you linked or join your table.

Regards

Vimlesh Gupta