topic Class Function in QlikView https://community.qlik.com/t5/QlikView/Class-Function/m-p/897683#M531361 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="309"><TBODY><TR><TD class="xl63" height="17" width="63">ALT_TIME</TD><TD class="xl63" style="border-left: none;" width="182">MAR</TD><TD class="xl63" style="border-left: none;" width="64">Different</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">00:34</TD><TD class="xl65" style="border-top: none; border-left: none;">150101SCBLAEADBXXX0708013155</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">59:28:50</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">00:39</TD><TD class="xl65" style="border-top: none; border-left: none;">150401SCBLAEADBXXX0724515379</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:35:44</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">00:57</TD><TD class="xl65" style="border-top: none; border-left: none;">150401SCBLAEADBXXX0724515584</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:18:13</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">00:57</TD><TD class="xl65" style="border-top: none; border-left: none;">150101SCBLAEADBXXX0708013158</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8:56:58</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">00:58</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838052</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5:04:17</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:00</TD><TD class="xl65" style="border-top: none; border-left: none;">141017SCBLAU2SXXXX0055094427</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2:51:18</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:00</TD><TD class="xl65" style="border-top: none; border-left: none;">141013SCBLAU2SXXXX0055991204</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">24:54:44</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:00</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838055</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:29:39</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:00</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838055</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:29:39</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:01</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838056</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:29:12</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:01</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838056</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:29:12</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:01</TD><TD class="xl65" style="border-top: none; border-left: none;">140929SCBLBDDXAXXX6390370811</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">50:38:52</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:02</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838058</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5:00:43</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:02</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838058</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5:00:43</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:02</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838059</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5:17:22</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:03</TD><TD class="xl65" style="border-top: none; border-left: none;">150401SCBLAEADBXXX0724515592</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2:44:46</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:03</TD><TD class="xl65" style="border-top: none; border-left: none;">141002SCBLAU2SXXXX0055833421</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">26:07:26</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:05</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838064</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5:20:53</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:07</TD><TD class="xl65" style="border-top: none; border-left: none;">150401SCBLAEADBXXX0724515593</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:18:42</TD></TR></TBODY></TABLE><P></P><P></P><P>My Requirement is to create a Bar chart with Dimension as Time Interval (0 -1 ,1-2,2-3) </P><P>with expression as % of MAR closed with in 1 hour based on Different column</P></BODY></HTML> Tue, 16 Jun 2015 05:48:31 GMT 2015-06-16T05:48:31Z Class Function https://community.qlik.com/t5/QlikView/Class-Function/m-p/897683#M531361 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="309"><TBODY><TR><TD class="xl63" height="17" width="63">ALT_TIME</TD><TD class="xl63" style="border-left: none;" width="182">MAR</TD><TD class="xl63" style="border-left: none;" width="64">Different</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">00:34</TD><TD class="xl65" style="border-top: none; border-left: none;">150101SCBLAEADBXXX0708013155</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">59:28:50</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">00:39</TD><TD class="xl65" style="border-top: none; border-left: none;">150401SCBLAEADBXXX0724515379</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:35:44</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">00:57</TD><TD class="xl65" style="border-top: none; border-left: none;">150401SCBLAEADBXXX0724515584</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:18:13</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">00:57</TD><TD class="xl65" style="border-top: none; border-left: none;">150101SCBLAEADBXXX0708013158</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8:56:58</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">00:58</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838052</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5:04:17</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:00</TD><TD class="xl65" style="border-top: none; border-left: none;">141017SCBLAU2SXXXX0055094427</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2:51:18</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:00</TD><TD class="xl65" style="border-top: none; border-left: none;">141013SCBLAU2SXXXX0055991204</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">24:54:44</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:00</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838055</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:29:39</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:00</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838055</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:29:39</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:01</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838056</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:29:12</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:01</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838056</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:29:12</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:01</TD><TD class="xl65" style="border-top: none; border-left: none;">140929SCBLBDDXAXXX6390370811</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">50:38:52</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:02</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838058</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5:00:43</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:02</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838058</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5:00:43</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:02</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838059</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5:17:22</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:03</TD><TD class="xl65" style="border-top: none; border-left: none;">150401SCBLAEADBXXX0724515592</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2:44:46</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:03</TD><TD class="xl65" style="border-top: none; border-left: none;">141002SCBLAU2SXXXX0055833421</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">26:07:26</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:05</TD><TD class="xl65" style="border-top: none; border-left: none;">141201SCBLAEADBXXX0703838064</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5:20:53</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">01:07</TD><TD class="xl65" style="border-top: none; border-left: none;">150401SCBLAEADBXXX0724515593</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3:18:42</TD></TR></TBODY></TABLE><P></P><P></P><P>My Requirement is to create a Bar chart with Dimension as Time Interval (0 -1 ,1-2,2-3) </P><P>with expression as % of MAR closed with in 1 hour based on Different column</P></BODY></HTML> Tue, 16 Jun 2015 05:48:31 GMT https://community.qlik.com/t5/QlikView/Class-Function/m-p/897683#M531361 2015-06-16T05:48:31Z Re: Class Function https://community.qlik.com/t5/QlikView/Class-Function/m-p/897684#M531362 <HTML><HEAD></HEAD><BODY><P>I don't understand your requirement. What field should be used as chart dimension?</P></BODY></HTML> Tue, 16 Jun 2015 11:19:59 GMT https://community.qlik.com/t5/QlikView/Class-Function/m-p/897684#M531362 Gysbert_Wassenaar 2015-06-16T11:19:59Z Re: Class Function https://community.qlik.com/t5/QlikView/Class-Function/m-p/897685#M531363 <HTML><HEAD></HEAD><BODY><P>I guess Kumar means ALT_TIME.</P><P>You can you class or interval match to create the time intervals in the load script. And then use the newly created field as a dimension.</P></BODY></HTML> Tue, 16 Jun 2015 11:22:40 GMT https://community.qlik.com/t5/QlikView/Class-Function/m-p/897685#M531363 giakoum 2015-06-16T11:22:40Z