topic Re: time bands in QlikView

topic Re: time bands in QlikView https://community.qlik.com/t5/QlikView/time-bands/m-p/458408#M171130 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" href="https://community.qlik.com/thread/52904">This discussion</A> might help you</P></BODY></HTML> Fri, 25 Jan 2013 15:18:49 GMT Gysbert_Wassenaar 2013-01-25T15:18:49Z time bands https://community.qlik.com/t5/QlikView/time-bands/m-p/458407#M171129 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>I have data with Date&Time field and corresponding Visits to it. I would like to plot a graph showing 30min trend.</P><P>e.g.</P><P>Time                         Visits</P><TABLE border="0" cellpadding="0" cellspacing="0" width="251"><TBODY><TR><TD class="xl93" height="17" width="110">0600</TD><TD class="xl94" style="border-left: none;" width="141">                                  1,004 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">0630</TD><TD class="xl94" style="border-top: none; border-left: none;">                                  1,403 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">0700</TD><TD class="xl94" style="border-top: none; border-left: none;">                                  1,987 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">0730</TD><TD class="xl94" style="border-top: none; border-left: none;">                                  2,916 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">0800</TD><TD class="xl94" style="border-top: none; border-left: none;">                                  3,063 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">0830</TD><TD class="xl94" style="border-top: none; border-left: none;">                                  4,875 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">0900</TD><TD class="xl94" style="border-top: none; border-left: none;">                                  6,356 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">0930</TD><TD class="xl94" style="border-top: none; border-left: none;">                                  7,415 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">1000</TD><TD class="xl94" style="border-top: none; border-left: none;">                                  6,454 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">1030</TD><TD class="xl94" style="border-top: none; border-left: none;">                                  6,786 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">1100</TD><TD class="xl94" style="border-top: none; border-left: none;">                                  8,298 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">1130</TD><TD class="xl94" style="border-top: none; border-left: none;">                                  8,276 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">1200</TD><TD class="xl94" style="border-top: none; border-left: none;">                                  9,074 </TD></TR><TR><TD class="xl93" height="17" style="border-top: none;">1230</TD><TD class="xl94" style="border-top: none; border-left: none;">                               10,341 </TD></TR></TBODY></TABLE><P></P><P>How can I agregate data on every 30min?</P><P>Any idea please?</P><P></P><P>Thanks</P></BODY></HTML> Fri, 25 Jan 2013 15:13:56 GMT https://community.qlik.com/t5/QlikView/time-bands/m-p/458407#M171129 2013-01-25T15:13:56Z Re: time bands https://community.qlik.com/t5/QlikView/time-bands/m-p/458408#M171130 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" href="https://community.qlik.com/thread/52904">This discussion</A> might help you</P></BODY></HTML> Fri, 25 Jan 2013 15:18:49 GMT https://community.qlik.com/t5/QlikView/time-bands/m-p/458408#M171130 Gysbert_Wassenaar 2013-01-25T15:18:49Z Re: time bands https://community.qlik.com/t5/QlikView/time-bands/m-p/458409#M171131 <HTML><HEAD></HEAD><BODY><P>It works thanks a lot.</P></BODY></HTML> Fri, 25 Jan 2013 16:15:06 GMT https://community.qlik.com/t5/QlikView/time-bands/m-p/458409#M171131 2013-01-25T16:15:06Z