topic Re: get first and last time at in QlikView https://community.qlik.com/t5/QlikView/get-first-and-last-time-at/m-p/67262#M777706 <HTML><HEAD></HEAD><BODY><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15242105215789137 jive_text_macro" jivemacro_uid="_15242105215789137"> <P><SPAN style="font-size: 13.3333px;">SET TimeFormat='h:mm TT';</SPAN></P> <P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P> <P><SPAN style="font-size: 13.3333px;">Data:</SPAN></P> <P><SPAN style="font-size: 13.3333px;">Load *</SPAN></P> <P><SPAN style="font-size: 13.3333px;">Inline</SPAN></P> <P><SPAN style="font-size: 13.3333px;">[</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> ID, TIME</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 125, 8:00 AM</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 125, 10:30 AM</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 125, 4:00 PM</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 225, 8:30 AM</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 225, 9:00 AM</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 225, 2:30 PM</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 225, 5:30 PM</SPAN></P> <P><SPAN style="font-size: 13.3333px;">];</SPAN></P> <P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P> <P><SPAN style="font-size: 13.3333px;">NoConcatenate</SPAN></P> <P><SPAN style="font-size: 13.3333px;">Final:</SPAN></P> <P><SPAN style="font-size: 13.3333px;">Load ID, Time(Min(TIME)) as TIME Resident Data Group By ID;</SPAN></P> <P><SPAN style="font-size: 13.3333px;">Load ID, Time(Max(TIME)) as TIME Resident Data Group By ID;</SPAN></P> <P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P> <P><SPAN style="font-size: 13.3333px;">Drop Table Data;</SPAN></P> </PRE></BODY></HTML> Fri, 20 Apr 2018 07:48:48 GMT MK_QSL 2018-04-20T07:48:48Z get first and last time at https://community.qlik.com/t5/QlikView/get-first-and-last-time-at/m-p/67261#M777703 <HTML><HEAD></HEAD><BODY><P>Hello There,</P><P>My concern is about how to get the first and last time Login and Logout.</P><P>Sample Data:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 127px;"><TBODY><TR><TD class="xl63" height="20" width="64">ID</TD><TD class="xl63" style="border-left: none;" width="63">TIME </TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">125</TD><TD class="xl64" style="border-top: none; border-left: none;">8:00 AM</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">125</TD><TD class="xl64" style="border-top: none; border-left: none;">10:30 AM</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">125</TD><TD class="xl64" style="border-top: none; border-left: none;">4:00 PM</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">225</TD><TD class="xl64" style="border-top: none; border-left: none;">8:30 AM</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">225</TD><TD class="xl64" style="border-top: none; border-left: none;">9:00 AM</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">225</TD><TD class="xl64" style="border-top: none; border-left: none;">2:30 PM</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">225</TD><TD class="xl64" style="border-top: none; border-left: none;">5:30 PM</TD></TR></TBODY></TABLE><P></P><P>Supposedly this is what i want time display.</P><P></P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid #000000; width: 105px; height: 125px;" width="103"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">TIME</TH></TR><TR><TD style="padding: 2px;"><P>125</P></TD><TD style="padding: 2px;">8:00 AM</TD></TR><TR><TD style="padding: 2px;">125</TD><TD style="padding: 2px;">4:00 PM</TD></TR><TR><TD style="padding: 2px;">225</TD><TD style="padding: 2px;">8:30 AM</TD></TR><TR><TD style="padding: 2px;">225</TD><TD style="padding: 2px;">5:30 PM</TD></TR></TBODY></TABLE><P></P><P></P><P>Best Regards,</P><P>Bing</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/get-first-and-last-time-at/m-p/67261#M777703 bsbernabe 2020-11-25T16:16:04Z Re: get first and last time at https://community.qlik.com/t5/QlikView/get-first-and-last-time-at/m-p/67262#M777706 <HTML><HEAD></HEAD><BODY><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15242105215789137 jive_text_macro" jivemacro_uid="_15242105215789137"> <P><SPAN style="font-size: 13.3333px;">SET TimeFormat='h:mm TT';</SPAN></P> <P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P> <P><SPAN style="font-size: 13.3333px;">Data:</SPAN></P> <P><SPAN style="font-size: 13.3333px;">Load *</SPAN></P> <P><SPAN style="font-size: 13.3333px;">Inline</SPAN></P> <P><SPAN style="font-size: 13.3333px;">[</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> ID, TIME</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 125, 8:00 AM</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 125, 10:30 AM</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 125, 4:00 PM</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 225, 8:30 AM</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 225, 9:00 AM</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 225, 2:30 PM</SPAN></P> <P><SPAN style="font-size: 13.3333px;"> 225, 5:30 PM</SPAN></P> <P><SPAN style="font-size: 13.3333px;">];</SPAN></P> <P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P> <P><SPAN style="font-size: 13.3333px;">NoConcatenate</SPAN></P> <P><SPAN style="font-size: 13.3333px;">Final:</SPAN></P> <P><SPAN style="font-size: 13.3333px;">Load ID, Time(Min(TIME)) as TIME Resident Data Group By ID;</SPAN></P> <P><SPAN style="font-size: 13.3333px;">Load ID, Time(Max(TIME)) as TIME Resident Data Group By ID;</SPAN></P> <P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P> <P><SPAN style="font-size: 13.3333px;">Drop Table Data;</SPAN></P> </PRE></BODY></HTML> Fri, 20 Apr 2018 07:48:48 GMT https://community.qlik.com/t5/QlikView/get-first-and-last-time-at/m-p/67262#M777706 MK_QSL 2018-04-20T07:48:48Z