# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for
Did you mean:
Contributor II

## Intermatch

Hi,

I am facing a problem with interval match. I need to match values of date and time from one table to date and time periods in another table. Intervalmatch is working fine except at two values of time i.e 2:15 and 3:45. Its showing null values where it is supposed to show matching time interval.
Second Problem is synthetic key, since im matching two columns from a single table to the other, it is creating a synthetic key.

My script is

Organization:
Organization,
Site,
"Data Point",
KWH,
Power,
C1,
C2,
C3,
V1,
V2,
V3,
Time("Time") as TIME,
Date("Date") as DATE
FROM [lib://Data/Dummy Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Peak:
Date("From") as From,
Date("TO") as To,
Time(FromTime) as FromTime,
Time(ToTime) as ToTime,
Status,
Tarrif
FROM [lib://Data/Dummy Data.xlsx]
(ooxml, embedded labels, table is Sheet2);

Inner Join
IntervalMatch(TIME)
FromTime,
ToTime
Resident Peak;

Inner Join
IntervalMatch(DATE, TIME)
From,
To,
TIME
Resident Peak;

Thank You

Labels (5)

• ### Qlik Sense

2 Replies
Partner

hi

have a look at the attachment

i changed the interval match to work with timestamp ,

i think this will solve your problems

Contributor II
Author

Thanks man!
It stops showing null values but it is not working as it should be. In data source 2:15 and 2:16 appears only once so they should only appear once against the interval they fall in, instead it is appearing against both the intervals.
Previously time was only appearing against its respective period but null value was appearing in 2:15 period, now that is solved but it is showing the time against the period it falls in as well as the period it dont fall in!