topic Re: Class in QlikView

topic Re: Class in QlikView https://community.qlik.com/t5/QlikView/Class/m-p/893254#M531427 <HTML><HEAD></HEAD><BODY><P>for your scenario , create Hour field by taking ALERT_DATE. by using bellow pseudo code </P><P>timestamp() or</P><P>time(field,'HH')</P><P></P><P>cheers</P></BODY></HTML> Mon, 15 Jun 2015 12:54:50 GMT ganeshreddy 2015-06-15T12:54:50Z Class https://community.qlik.com/t5/QlikView/Class/m-p/893252#M531425 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="1112"><TBODY><TR><TD height="20" width="70">ACT_DATE</TD><TD width="68">ALT_DATE</TD><TD width="34">DIFF</TD><TD width="64">AACTION</TD><TD width="215">MAR</TD><TD width="158">ALERT_DATE</TD><TD width="158">ALERT_ACTION_DATE</TD><TD width="130">ALT_ACTN_USER_ID</TD><TD width="107">BUS_UNIT_DESC</TD><TD width="108">COUNTRY_CODE</TD></TR><TR><TD align="right" class="xl63" height="20">2-Feb-15</TD><TD align="right" class="xl63">31-Jan-15</TD><TD align="right">2</TD><TD>OK</TD><TD>150131SCBLCIABAXXX3540298443</TD><TD>2015-01-31T10:51:34.36Z</TD><TD>2015-02-02T06:49:45.49Z</TD><TD align="right">1498984</TD><TD>Payments</TD><TD>IC</TD></TR><TR><TD align="right" class="xl63" height="20">2-Feb-15</TD><TD align="right" class="xl63">31-Jan-15</TD><TD align="right">2</TD><TD>OK</TD><TD>150131SCBLCIABAXXX3540298443</TD><TD>2015-01-31T10:51:34.36Z</TD><TD>2015-02-02T06:49:45.49Z</TD><TD align="right">1498984</TD><TD>Payments</TD><TD>IC</TD></TR><TR><TD align="right" class="xl63" height="20">2-Feb-15</TD><TD align="right" class="xl63">2-Feb-15</TD><TD align="right">0</TD><TD>OK</TD><TD>150202SCBLCIABXXXX0052718356</TD><TD>2015-02-02T01:00:21.40Z</TD><TD>2015-02-02T06:50:16.83Z</TD><TD align="right">1498984</TD><TD>Trade</TD><TD>IC</TD></TR><TR><TD align="right" class="xl63" height="20">2-Feb-15</TD><TD align="right" class="xl63">2-Feb-15</TD><TD align="right">0</TD><TD>OK</TD><TD>150202SCBLCIABXXXX0052718356</TD><TD>2015-02-02T01:00:21.40Z</TD><TD>2015-02-02T06:50:16.83Z</TD><TD align="right">1498984</TD><TD>Trade</TD><TD>IC</TD></TR><TR><TD align="right" class="xl63" height="20">2-Feb-15</TD><TD align="right" class="xl63">2-Feb-15</TD><TD align="right">0</TD><TD>OK</TD><TD>150202SCBLCIABAXXX3541298452</TD><TD>2015-02-02T07:28:20.85Z</TD><TD>2015-02-02T07:55:08.09Z</TD><TD align="right">1498984</TD><TD>Payments</TD><TD>IC</TD></TR><TR><TD align="right" class="xl63" height="20">2-Feb-15</TD><TD align="right" class="xl63">2-Feb-15</TD><TD align="right">0</TD><TD>OK</TD><TD>150202SCBLCIABAXXX3541298448</TD><TD>2015-02-02T02:06:45.50Z</TD><TD>2015-02-02T08:27:46.71Z</TD><TD align="right">1415664</TD><TD>Payments</TD><TD>IC</TD></TR><TR><TD align="right" class="xl63" height="20">2-Feb-15</TD><TD align="right" class="xl63">2-Feb-15</TD><TD align="right">0</TD><TD>ERRIDE</TD><TD>150202SCBLCIABAXXX3541298448</TD><TD>2015-02-02T02:06:45.50Z</TD><TD>2015-02-02T08:27:46.71Z</TD><TD align="right">1415664</TD><TD>Payments</TD><TD>IC</TD></TR></TBODY></TABLE><P>Requirement is : </P><P>I have to Find the No of MAR and the average time between ALERT_DATE and ALERT_ACTION_DATE on a hourly basis</P><P>Eg: creating Buckets based on  Hour of ALERT_DATE</P></BODY></HTML> Mon, 15 Jun 2015 12:39:53 GMT https://community.qlik.com/t5/QlikView/Class/m-p/893252#M531425 2015-06-15T12:39:53Z Re: Class https://community.qlik.com/t5/QlikView/Class/m-p/893253#M531426 <HTML><HEAD></HEAD><BODY><P>Hi Senthil,</P><P></P><P>The following link may help you, which i have created few months back.</P><P></P><P><A href="https://community.qlik.com/docs/DOC-8276">Bucket Creation In List Box</A></P><P></P><P>Cheers,</P><P>Ganesh. </P></BODY></HTML> Mon, 15 Jun 2015 12:50:09 GMT https://community.qlik.com/t5/QlikView/Class/m-p/893253#M531426 ganeshreddy 2015-06-15T12:50:09Z Re: Class https://community.qlik.com/t5/QlikView/Class/m-p/893254#M531427 <HTML><HEAD></HEAD><BODY><P>for your scenario , create Hour field by taking ALERT_DATE. by using bellow pseudo code </P><P>timestamp() or</P><P>time(field,'HH')</P><P></P><P>cheers</P></BODY></HTML> Mon, 15 Jun 2015 12:54:50 GMT https://community.qlik.com/t5/QlikView/Class/m-p/893254#M531427 ganeshreddy 2015-06-15T12:54:50Z