topic Time interval with seperate values in QlikView

Time interval with seperate values

tka_ovako — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Time interval with seperate values

swuehl — Mon, 17 Sep 2018 11:24:42 GMT

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.

Re: Time interval with seperate values

felipedl — Mon, 17 Sep 2018 11:52:33 GMT

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/IntervalMatch.htm

for example on how to use it.

Felipe.