Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Time Interval (Timeseries analysis)

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.

1 Reply
MarcoWedel

Hi,

maybe one solution could be:

QlikCommunity_Thread_249017_Pic1.JPG

QlikCommunity_Thread_249017_Pic2.JPG

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