Time interval with seperate values

[tka_ovako]

Hello.

Is there any chance to get data from two time set. I have table1 that contain times. Then I have another table2 that contains both times and measured values. Now I need to get those measured values somehow so first I get one timestamp from table1 and then compare timestamps with table2. So I need to get values from table2 plus minus 2 minutes compared to table1.

Pretty hard to explain this.

BR.

Timo

[swuehl]

Load your table one and create intervals plus minus 2 minutes for each timestamp:

LOAD

     Timestamp,

     (Timestamp - Maketime(0,2)) as RangeStart,

     (Timestamp + Maketime(0,2)) as RangeEnd

FROM Table1;

Then use IntervalMatch() to match the Table2 Timestamps into the ranges.

[felipedl]

Hi Timo,

You can use intervalmatch to match the timestamp from table 1 to table 2 values.

Table 1 needs to have a start and end timestamp so the table 2 value can be matched.

See https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

for example on how to use it.

Felipe.