topic same user working on same task!need to calculate time on UserAction Checherd-Out &In,how to calculate? in QlikView https://community.qlik.com/t5/QlikView/same-user-working-on-same-task-need-to-calculate-time-on/m-p/576407#M214454 <HTML><HEAD></HEAD><BODY><P>data is like this,</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="290"><TBODY><TR><TD height="20" width="64">DocId</TD><TD width="122">UserAction</TD><TD width="104">UpdateDate</TD></TR><TR><TD class="xl67" height="20">00005376</TD><TD class="xl71" style="border-left: none;">Item Added</TD><TD align="right" class="xl63" style="border-left: none;">2/12/2014 9:23</TD></TR><TR><TD class="xl68" height="20">00005376</TD><TD class="xl72" style="border-left: none;">Item Updated</TD><TD align="right" class="xl64" style="border-left: none;">2/12/2014 10:44</TD></TR><TR><TD class="xl69" height="20">00005376</TD><TD class="xl73" style="border-left: none;">Item Checked-Out</TD><TD align="right" class="xl65" style="border-left: none;">2/12/2014 10:51</TD></TR><TR><TD class="xl68" height="20">00005376</TD><TD class="xl72" style="border-left: none;">Item Checked-In</TD><TD align="right" class="xl64" style="border-left: none;">2/12/2014 11:03</TD></TR><TR><TD class="xl69" height="20">00005376</TD><TD class="xl73" style="border-left: none;">Item Checked-Out</TD><TD align="right" class="xl65" style="border-left: none;">2/12/2014 11:03</TD></TR><TR><TD class="xl68" height="20">00005376</TD><TD class="xl72" style="border-left: none;">Item Checked-In</TD><TD align="right" class="xl64" style="border-left: none;">2/12/2014 11:11</TD></TR><TR><TD class="xl70" height="20">00005376</TD><TD class="xl74" style="border-left: none;">Item Checked-Out</TD><TD align="right" class="xl66" style="border-left: none;">2/12/2014 11:23</TD></TR></TBODY></TABLE><P></P><P>any help!</P></BODY></HTML> Wed, 12 Feb 2014 17:29:58 GMT buzzy996 2014-02-12T17:29:58Z same user working on same task!need to calculate time on UserAction Checherd-Out &In,how to calculate? https://community.qlik.com/t5/QlikView/same-user-working-on-same-task-need-to-calculate-time-on/m-p/576407#M214454 <HTML><HEAD></HEAD><BODY><P>data is like this,</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="290"><TBODY><TR><TD height="20" width="64">DocId</TD><TD width="122">UserAction</TD><TD width="104">UpdateDate</TD></TR><TR><TD class="xl67" height="20">00005376</TD><TD class="xl71" style="border-left: none;">Item Added</TD><TD align="right" class="xl63" style="border-left: none;">2/12/2014 9:23</TD></TR><TR><TD class="xl68" height="20">00005376</TD><TD class="xl72" style="border-left: none;">Item Updated</TD><TD align="right" class="xl64" style="border-left: none;">2/12/2014 10:44</TD></TR><TR><TD class="xl69" height="20">00005376</TD><TD class="xl73" style="border-left: none;">Item Checked-Out</TD><TD align="right" class="xl65" style="border-left: none;">2/12/2014 10:51</TD></TR><TR><TD class="xl68" height="20">00005376</TD><TD class="xl72" style="border-left: none;">Item Checked-In</TD><TD align="right" class="xl64" style="border-left: none;">2/12/2014 11:03</TD></TR><TR><TD class="xl69" height="20">00005376</TD><TD class="xl73" style="border-left: none;">Item Checked-Out</TD><TD align="right" class="xl65" style="border-left: none;">2/12/2014 11:03</TD></TR><TR><TD class="xl68" height="20">00005376</TD><TD class="xl72" style="border-left: none;">Item Checked-In</TD><TD align="right" class="xl64" style="border-left: none;">2/12/2014 11:11</TD></TR><TR><TD class="xl70" height="20">00005376</TD><TD class="xl74" style="border-left: none;">Item Checked-Out</TD><TD align="right" class="xl66" style="border-left: none;">2/12/2014 11:23</TD></TR></TBODY></TABLE><P></P><P>any help!</P></BODY></HTML> Wed, 12 Feb 2014 17:29:58 GMT https://community.qlik.com/t5/QlikView/same-user-working-on-same-task-need-to-calculate-time-on/m-p/576407#M214454 buzzy996 2014-02-12T17:29:58Z