Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
abdulrahman
Contributor II
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
lironbaram
Partner
Partner

hi 

have a look at the attachment 

i changed the interval match to work with timestamp ,  

i think this will solve your problems 

abdulrahman
Contributor II
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!