Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
abdulrahman
New 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:
LOAD
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:
LOAD
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)
Load
FromTime,
ToTime
Resident Peak;

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

Thank You

2 Replies
Highlighted
Partner
Partner

Re: Intermatch

hi 

have a look at the attachment 

i changed the interval match to work with timestamp ,  

i think this will solve your problems 

Highlighted
abdulrahman
New Contributor II

Re: Intermatch

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!