topic How to create buckets using time in QlikView https://community.qlik.com/t5/QlikView/How-to-create-buckets-using-time/m-p/1549817#M440160 <P>Hi,</P><P>&nbsp;I want to create four buckets as below using the Closed in time field.&nbsp;</P><P>1. &lt;=5PM -Wd2 ( Starts from 12AM of WD+1 to 5PM&nbsp;&nbsp;of WD+2)<BR />2. &gt;5PM - Wd2&nbsp;&nbsp;( Starts after 5PM of WD+2 to 12 AM of&nbsp; WD+3)<BR />3. &lt;=5PM - Wd3&nbsp;&nbsp;( Starts from 12 AM of WD+3 to 5 PM of&nbsp; WD+3)<BR />4. &gt;5PM - Wd3&nbsp;&nbsp;( Starts after 5PM of WD+3)</P><P>I have three workdays WD+1,WD+2 and WD+3.&nbsp;I want to calculate the Count of ID's for these four time slots in bar graph. Please find the data attached and please help me to get the result.</P><P>Ex: for this group &lt;=5PM -Wd2 what is the count of ID's. Similarly for all four groups.</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;</P> Wed, 27 Feb 2019 12:31:40 GMT farheenayesha 2019-02-27T12:31:40Z How to create buckets using time https://community.qlik.com/t5/QlikView/How-to-create-buckets-using-time/m-p/1549817#M440160 <P>Hi,</P><P>&nbsp;I want to create four buckets as below using the Closed in time field.&nbsp;</P><P>1. &lt;=5PM -Wd2 ( Starts from 12AM of WD+1 to 5PM&nbsp;&nbsp;of WD+2)<BR />2. &gt;5PM - Wd2&nbsp;&nbsp;( Starts after 5PM of WD+2 to 12 AM of&nbsp; WD+3)<BR />3. &lt;=5PM - Wd3&nbsp;&nbsp;( Starts from 12 AM of WD+3 to 5 PM of&nbsp; WD+3)<BR />4. &gt;5PM - Wd3&nbsp;&nbsp;( Starts after 5PM of WD+3)</P><P>I have three workdays WD+1,WD+2 and WD+3.&nbsp;I want to calculate the Count of ID's for these four time slots in bar graph. Please find the data attached and please help me to get the result.</P><P>Ex: for this group &lt;=5PM -Wd2 what is the count of ID's. Similarly for all four groups.</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;</P> Wed, 27 Feb 2019 12:31:40 GMT https://community.qlik.com/t5/QlikView/How-to-create-buckets-using-time/m-p/1549817#M440160 farheenayesha 2019-02-27T12:31:40Z Re: How to create buckets using time https://community.qlik.com/t5/QlikView/How-to-create-buckets-using-time/m-p/1549819#M440161 <P>Would you be able to specify the expected output based on the data provided? and may be explain it a little</P> Wed, 27 Feb 2019 12:32:11 GMT https://community.qlik.com/t5/QlikView/How-to-create-buckets-using-time/m-p/1549819#M440161 sunny_talwar 2019-02-27T12:32:11Z Re: How to create buckets using time https://community.qlik.com/t5/QlikView/How-to-create-buckets-using-time/m-p/1549952#M440177 <P>Hi Sunny,</P><P>I have added month field in the attached data. Please consider the new data file attached.</P><P>&nbsp;Ex. If i take the&nbsp; data only for&nbsp;&lt;=5PM -Wd2 and Jul Month, which includes records having time less than 5PM, then the count of ID's should be 98.&nbsp; Please find the data below.&nbsp; also attaching the complete data.</P><TABLE><TBODY><TR><TD>Closed in WD</TD><TD>Closed in Time</TD><TD>ID</TD><TD>Month</TD></TR><TR><TD>WD+2</TD><TD>4:50 PM</TD><TD>AT01</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>4:50 PM</TD><TD>AT02</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>4:56 PM</TD><TD>DE19</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>4:46 PM</TD><TD>DE25</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>4:30 PM</TD><TD>DE28</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>3:10 PM</TD><TD>ES09</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>4:58 PM</TD><TD>FR05</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>4:07 PM</TD><TD>GB66</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>2:26 PM</TD><TD>IE01</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>4:07 PM</TD><TD>IE04</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>4:07 PM</TD><TD>IE05</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>4:23 PM</TD><TD>IE10</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>4:30 PM</TD><TD>IE12</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>4:23 PM</TD><TD>IE16</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>3:12 PM</TD><TD>IE17</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>3:12 PM</TD><TD>IE18</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>3:12 PM</TD><TD>IT01</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>3:12 PM</TD><TD>IT02</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>3:12 PM</TD><TD>IT03</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>3:12 PM</TD><TD>IT04</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>3:09 PM</TD><TD>NL01</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>2:46 PM</TD><TD>NL06</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>2:46 PM</TD><TD>NL08</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>2:46 PM</TD><TD>NO01</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>2:46 PM</TD><TD>NO02</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>2:46 PM</TD><TD>NO04</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>2:46 PM</TD><TD>PL01</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>2:46 PM</TD><TD>PL03</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>2:46 PM</TD><TD>PT01</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>2:46 PM</TD><TD>PT02</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>2:11 PM</TD><TD>PT04</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>5:00 AM</TD><TD>PT07</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>5:00 AM</TD><TD>PT08</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>5:00 AM</TD><TD>US46</TD><TD>July'18</TD></TR><TR><TD>WD+2</TD><TD>5:00 AM</TD><TD>US50</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>USAF</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:30 PM</TD><TD>FR09</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:30 PM</TD><TD>GB02</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB06</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB08</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB09</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB19</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB1A</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB20</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB21</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB22</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:30 PM</TD><TD>GB23</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB24</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:30 PM</TD><TD>GB25</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB26</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB30</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB31</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:30 PM</TD><TD>GB33</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:30 PM</TD><TD>GB34</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB35</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB38</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB39</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:30 PM</TD><TD>GB40</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB41</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB42</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB44</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB45</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB47</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB49</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB55</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB58</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB59</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB5Q</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB64</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB70</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB71</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB73</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB74</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB78</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB80</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>5:00 PM</TD><TD>GB81</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:30 PM</TD><TD>GB82</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB83</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB84</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB87</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB88</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB89</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB91</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB93</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB94</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GB95</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GBAJ</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GBAL</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GBAU</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GBAV</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GBAY</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GBBC</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GBBF</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:30 PM</TD><TD>GBCD</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GBCE</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:00 PM</TD><TD>GBCF</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>4:30 PM</TD><TD>GBCG</TD><TD>July'18</TD></TR><TR><TD>WD+2&nbsp;</TD><TD>04.03 AM</TD><TD>ID04</TD><TD>July'18</TD></TR></TBODY></TABLE> Wed, 27 Feb 2019 15:17:28 GMT https://community.qlik.com/t5/QlikView/How-to-create-buckets-using-time/m-p/1549952#M440177 farheenayesha 2019-02-27T15:17:28Z