Time Interval (Timeseries analysis)

[#1]

Hi All,

I am looking for an solution which can help me to split my datetimestatp into time (2 minute interval).

Actually, i need to create 720 filed (00 hours to 11:59 hours) with 2 minute timeinterval and mark values based on start and date.

Based on output, i need to create an line chart and show 2minute (720 filed) trend (time serise analysis)

Sample data attached for your reference.

[MarcoWedel]

Hi,

maybe one solution could be:

table1:
LOAD Sno,
    StartDate,
    EndDate
FROM [https://community.qlik.com/servlet/JiveServlet/download/1207974-264488/data-qlik.xlsx] (ooxml, embedded labels, table is Sheet1, filters(Remove(Row, Pos(Top, 1)),Remove(Row, Pos(Top, 7)),Remove(Row, Pos(Top, 6)),Remove(Row, Pos(Top, 5)),Remove(Row, Pos(Top, 4))));

tabLink:
LOAD Sno,
    Time#(Time(Ceil(Frac(StartDate),'00:02')+(IterNo()-1)*'00:02','hh:mm'),'hh:mm') as Time
Resident table1
While Time#(Time(Ceil(Frac(StartDate),'00:02')+(IterNo()-1)*'00:02','hh:mm'),'hh:mm')<=Frac(EndDate);

tabTime:
LOAD *,
    Hour(Time) as Hour,
    Minute(Time) as Minute;
LOAD Time#(Time((RecNo()-1)*'00:02','hh:mm'),'hh:mm') as Time
AutoGenerate 1/'00:02';

hope this helps

regards

Marco