Interval match

[samuel_brierley]

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.

Dropbox - qlikview.xlsm

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]

PFA

[samuel_brierley]

sorry i only have the trial I cant open them

[#4]

Dear

Try it will work.

A:

load

     Key,

     [Date Detected],

     [Date Cleared]

     FROM

[blah blah blah]

(ooxml, embedded labels, table is Halogen);

B:

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