topic Group by time and date in QlikView https://community.qlik.com/t5/QlikView/Group-by-time-and-date/m-p/938799#M956370 <HTML><HEAD></HEAD><BODY><P>Hi, I have events table and those events happen in different times. i want to get previous day events and categorize them based on shifts.</P><P></P><P>My Shifts are 06:30 - 14 :30 </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14:30 - 22 :30</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22 : 30 - 06 :30</P><P></P><P>My event date is in 11-04-2015 5:17:00 PM format.</P><P></P><P>I want to get the event day counts in last 3 complete shifts. ( if i reload it on&nbsp; 11 - 04 - 2015 03 : 00 am </P><P></P><P>Then i'm considering&nbsp;&nbsp;&nbsp; 14 : 30 - 22 :30&nbsp; on <SPAN style="font-size: 13.3333px;">11 - 03 - 2015</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">06:30 - 14 :30 on </SPAN> <SPAN style="font-size: 13.3333px;">11 - 03 - 2015</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> 22 : 30 - 06 :30 on <SPAN style="font-size: 13.3333px;">11 - 02- 2015</SPAN></SPAN></SPAN>&nbsp;&nbsp;&nbsp;&nbsp; as three complete shits.</SPAN></P><P></P><P></P><P>Can i do it by not doing changes in scripts ?</P><P></P><P>or else how can i solve this problem.</P><P></P><P>Thanks in Advance</P></BODY></HTML> Thu, 05 Nov 2015 06:12:49 GMT anuradhaa 2015-11-05T06:12:49Z Group by time and date https://community.qlik.com/t5/QlikView/Group-by-time-and-date/m-p/938799#M956370 <HTML><HEAD></HEAD><BODY><P>Hi, I have events table and those events happen in different times. i want to get previous day events and categorize them based on shifts.</P><P></P><P>My Shifts are 06:30 - 14 :30 </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14:30 - 22 :30</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22 : 30 - 06 :30</P><P></P><P>My event date is in 11-04-2015 5:17:00 PM format.</P><P></P><P>I want to get the event day counts in last 3 complete shifts. ( if i reload it on&nbsp; 11 - 04 - 2015 03 : 00 am </P><P></P><P>Then i'm considering&nbsp;&nbsp;&nbsp; 14 : 30 - 22 :30&nbsp; on <SPAN style="font-size: 13.3333px;">11 - 03 - 2015</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">06:30 - 14 :30 on </SPAN> <SPAN style="font-size: 13.3333px;">11 - 03 - 2015</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> 22 : 30 - 06 :30 on <SPAN style="font-size: 13.3333px;">11 - 02- 2015</SPAN></SPAN></SPAN>&nbsp;&nbsp;&nbsp;&nbsp; as three complete shits.</SPAN></P><P></P><P></P><P>Can i do it by not doing changes in scripts ?</P><P></P><P>or else how can i solve this problem.</P><P></P><P>Thanks in Advance</P></BODY></HTML> Thu, 05 Nov 2015 06:12:49 GMT https://community.qlik.com/t5/QlikView/Group-by-time-and-date/m-p/938799#M956370 anuradhaa 2015-11-05T06:12:49Z Re: Group by time and date https://community.qlik.com/t5/QlikView/Group-by-time-and-date/m-p/938800#M956371 <HTML><HEAD></HEAD><BODY><P>Can you post a small qlikview document with example data?</P></BODY></HTML> Thu, 05 Nov 2015 10:57:02 GMT https://community.qlik.com/t5/QlikView/Group-by-time-and-date/m-p/938800#M956371 Gysbert_Wassenaar 2015-11-05T10:57:02Z Re: Group by time and date https://community.qlik.com/t5/QlikView/Group-by-time-and-date/m-p/938801#M956372 <HTML><HEAD></HEAD><BODY><P>Do you have Shift table as well along with Event Table?</P></BODY></HTML> Thu, 05 Nov 2015 11:00:48 GMT https://community.qlik.com/t5/QlikView/Group-by-time-and-date/m-p/938801#M956372 Anonymous 2015-11-05T11:00:48Z Re: Group by time and date https://community.qlik.com/t5/QlikView/Group-by-time-and-date/m-p/938802#M956373 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">It's not that accurate,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Please find attached for times.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I need to put them to latest 3 shifts,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">06:30 - 14:30 </SPAN></P><P style="font-size: 13.3333px;"><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">14:30 - <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">22:30</SPAN></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">22:30 - 06.30 next day </SPAN></P></BODY></HTML> Thu, 05 Nov 2015 14:18:04 GMT https://community.qlik.com/t5/QlikView/Group-by-time-and-date/m-p/938802#M956373 anuradhaa 2015-11-05T14:18:04Z