topic Re: class range two hours in QlikView https://community.qlik.com/t5/QlikView/class-range-two-hours/m-p/981480#M335032 <HTML><HEAD></HEAD><BODY><P>I don't really understand what you are trying to do here.</P></BODY></HTML> Wed, 09 Dec 2015 19:53:44 GMT sunny_talwar 2015-12-09T19:53:44Z class range two hours https://community.qlik.com/t5/QlikView/class-range-two-hours/m-p/981479#M335031 <HTML><HEAD></HEAD><BODY><P>hi i need to class two hours !!</P><P>for example</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>range<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">operator</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>hour login<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>hour logout<BR /></STRONG></TH></TR><TR><TD style="padding: 2px;"><P>09:00-10:00</P></TD><TD style="padding: 2px;">alex</TD><TD style="padding: 2px;">08:30</TD><TD style="padding: 2px;">10:50</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">simon</TD><TD style="padding: 2px;">09:00</TD><TD style="padding: 2px;">09:30</TD></TR></TBODY></TABLE><P></P><P>usually i used clas with only one value !!!</P><P>how can i do ?</P></BODY></HTML> Wed, 09 Dec 2015 15:45:52 GMT https://community.qlik.com/t5/QlikView/class-range-two-hours/m-p/981479#M335031 2015-12-09T15:45:52Z Re: class range two hours https://community.qlik.com/t5/QlikView/class-range-two-hours/m-p/981480#M335032 <HTML><HEAD></HEAD><BODY><P>I don't really understand what you are trying to do here.</P></BODY></HTML> Wed, 09 Dec 2015 19:53:44 GMT https://community.qlik.com/t5/QlikView/class-range-two-hours/m-p/981480#M335032 sunny_talwar 2015-12-09T19:53:44Z Re: class range two hours https://community.qlik.com/t5/QlikView/class-range-two-hours/m-p/981481#M335033 <HTML><HEAD></HEAD><BODY><P>thanks for reply, i<SPAN class="short_text" lang="en"><SPAN class="hps"> try to</SPAN> <SPAN class="hps">explain better</SPAN></SPAN> </P><P>my table have multiple timestamp login of operators</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">operator</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">login</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">logout</TH></TR><TR><TD style="padding: 2px;">alex</TD><TD style="padding: 2px;">09:30</TD><TD style="padding: 2px;">10:50</TD></TR><TR><TD style="padding: 2px;">simon</TD><TD style="padding: 2px;">10:20</TD><TD style="padding: 2px;">13:10</TD></TR></TBODY></TABLE><P></P><P><SPAN lang="en"><SPAN class="hps">I need to</SPAN> <SPAN class="hps">count the minutes</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">login for</SPAN> <SPAN class="hps">each operator</SPAN> <SPAN class="hps">divided</SPAN> <SPAN class="hps">by hour (variable, can be 60 minutes, 30 minutes, etc)<BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">operator</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">range</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">minutes logged</TH></TR><TR><TD style="padding: 2px;">alex</TD><TD style="padding: 2px;">09:00 to 10:00</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">10:00 to 11:00</TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;">simon</TD><TD style="padding: 2px;">10:00 to 11:00</TD><TD style="padding: 2px;"><P>40</P></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">11:00 to 12:00</TD><TD style="padding: 2px;">60</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">12:00 to 13:00</TD><TD style="padding: 2px;">60</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">13:00 to 14:00</TD><TD style="padding: 2px;">10</TD></TR></TBODY></TABLE><P><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps">usually for range a field i use "class", but my problem here i have two fields: login and logout..<BR /></SPAN></SPAN></P></BODY></HTML> Thu, 10 Dec 2015 09:36:40 GMT https://community.qlik.com/t5/QlikView/class-range-two-hours/m-p/981481#M335033 2015-12-10T09:36:40Z