Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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