topic Re: Sort the time in the time group in QlikView https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304206#M618723 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try creating a inline table with your time groups and then use the intervalmatch function to associate times to time groups.</P><P></P><P>Kind Regards</P><P>Kamiel</P></BODY></HTML> Tue, 25 Apr 2017 11:54:47 GMT kamielrajaram 2017-04-25T11:54:47Z Sort the time in the time group https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304198#M618715 <HTML><HEAD></HEAD><BODY><P>I need help to sort the time (UsedTime) in the time group, for example:</P><P></P><P>Time Groups:</P><P>07:00 to 12:59</P><P>13:00 to 18:59</P><P>19:00 to 22:59</P><P>23:00 to 06:59</P><P></P><P><IMG alt="2017-04-24 - 001.png" class="jive-image image-1" src="/legacyfs/online/160981_2017-04-24 - 001.png" style="height: auto;" /></P><P></P><P>Example: Cod 111 have the total time of 02:45, but 44 minutes need to join the group 13:00 to 18:59 and 2hours and 1 minute to the group 19:00 to 22:59.</P><P></P><P>Can someone help me?</P><P></P><P>Thank you.</P></BODY></HTML> Mon, 24 Apr 2017 11:53:33 GMT https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304198#M618715 dairan73 2017-04-24T11:53:33Z Re: Sort the time in the time group https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304199#M618716 <HTML><HEAD></HEAD><BODY><P>You need this in the script or front end? and where are the Time Groups? In another table?</P></BODY></HTML> Mon, 24 Apr 2017 11:58:25 GMT https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304199#M618716 sunny_talwar 2017-04-24T11:58:25Z Re: Sort the time in the time group https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304200#M618717 <HTML><HEAD></HEAD><BODY><P>I prefer in the script.</P><P>Time Groups not existis in a table, the user told me.</P></BODY></HTML> Mon, 24 Apr 2017 12:09:15 GMT https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304200#M618717 dairan73 2017-04-24T12:09:15Z Re: Sort the time in the time group https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304201#M618718 <HTML><HEAD></HEAD><BODY><P>So these groups can change or are these always going to be the same?</P></BODY></HTML> Mon, 24 Apr 2017 12:12:24 GMT https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304201#M618718 sunny_talwar 2017-04-24T12:12:24Z Re: Sort the time in the time group https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304202#M618719 <HTML><HEAD></HEAD><BODY><P>The groups will always be the same.</P></BODY></HTML> Mon, 24 Apr 2017 12:14:56 GMT https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304202#M618719 dairan73 2017-04-24T12:14:56Z Re: Sort the time in the time group https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304203#M618720 <HTML><HEAD></HEAD><BODY><P>Any idea ?</P></BODY></HTML> Tue, 25 Apr 2017 11:48:53 GMT https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304203#M618720 dairan73 2017-04-25T11:48:53Z Re: Sort the time in the time group https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304204#M618721 <HTML><HEAD></HEAD><BODY><P>Do you know how to do ?</P></BODY></HTML> Tue, 25 Apr 2017 11:49:43 GMT https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304204#M618721 dairan73 2017-04-25T11:49:43Z Re: Sort the time in the time group https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304205#M618722 <HTML><HEAD></HEAD><BODY><P>As per your data what was the output you want to see?</P></BODY></HTML> Tue, 25 Apr 2017 11:51:25 GMT https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304205#M618722 Anil_Babu_Samineni 2017-04-25T11:51:25Z Re: Sort the time in the time group https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304206#M618723 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try creating a inline table with your time groups and then use the intervalmatch function to associate times to time groups.</P><P></P><P>Kind Regards</P><P>Kamiel</P></BODY></HTML> Tue, 25 Apr 2017 11:54:47 GMT https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304206#M618723 kamielrajaram 2017-04-25T11:54:47Z Re: Sort the time in the time group https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304207#M618724 <HTML><HEAD></HEAD><BODY><P>I need to look like this:</P><P><IMG alt="2017-04-25 - 001.png" class="jive-image image-1" src="/legacyfs/online/161161_2017-04-25 - 001.png" style="height: auto;" /></P></BODY></HTML> Tue, 25 Apr 2017 12:45:45 GMT https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304207#M618724 dairan73 2017-04-25T12:45:45Z Re: Sort the time in the time group https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304208#M618725 <HTML><HEAD></HEAD><BODY><P>But with the intervalmatch I can't put the minutes of the same Cod in more than one group (Look at the image of the answer above).</P></BODY></HTML> Tue, 25 Apr 2017 12:47:35 GMT https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304208#M618725 dairan73 2017-04-25T12:47:35Z Re: Sort the time in the time group https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304209#M618726 <HTML><HEAD></HEAD><BODY><P>Got it this far</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/161171_Capture.PNG" style="height: auto;" /></P><P></P><P>Did not get the time to fix the Cod 555, may be someone else can take it forward from here</P></BODY></HTML> Tue, 25 Apr 2017 12:57:13 GMT https://community.qlik.com/t5/QlikView/Sort-the-time-in-the-time-group/m-p/1304209#M618726 sunny_talwar 2017-04-25T12:57:13Z