topic What datatype to make calculation? in QlikView https://community.qlik.com/t5/QlikView/What-datatype-to-make-calculation/m-p/355632#M1174430 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Use TimeStamp for this type of data.</P><P></P><P>Celambarasan</P></BODY></HTML> Tue, 17 Apr 2012 16:10:08 GMT CELAMBARASAN 2012-04-17T16:10:08Z What datatype to make calculation? https://community.qlik.com/t5/QlikView/What-datatype-to-make-calculation/m-p/355631#M1174429 <HTML><HEAD></HEAD><BODY><P>Goal:</P><P>Display the value in hours by calculating end - begin.</P><P></P><P>Problem</P><P></P><P>I have table with data</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 300px; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Begin</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>End</STRONG></SPAN></TH></TR><TR><TD>2011-11-10 12:12:12</TD><TD>2011-11-12 12:12:12</TD></TR><TR><TD>2011-11-10 12:12:12</TD><TD>2011-11-11 08:12:12</TD></TR></TBODY></TABLE><P></P><P>I need help with following issue:<BR />*What datatype do I need to use in order calculate? I need a similiar datatype as datatime from SQL server. It doesn't work to use QlikView's datatype date to make a calculation</P><P></P><P>// JJ</P></BODY></HTML> Tue, 17 Apr 2012 15:32:41 GMT https://community.qlik.com/t5/QlikView/What-datatype-to-make-calculation/m-p/355631#M1174429 2012-04-17T15:32:41Z What datatype to make calculation? https://community.qlik.com/t5/QlikView/What-datatype-to-make-calculation/m-p/355632#M1174430 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Use TimeStamp for this type of data.</P><P></P><P>Celambarasan</P></BODY></HTML> Tue, 17 Apr 2012 16:10:08 GMT https://community.qlik.com/t5/QlikView/What-datatype-to-make-calculation/m-p/355632#M1174430 CELAMBARASAN 2012-04-17T16:10:08Z What datatype to make calculation? https://community.qlik.com/t5/QlikView/What-datatype-to-make-calculation/m-p/355633#M1174431 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; To get hour difference use Interval method</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Interval(End-Begin,'hh') which will give you the hour difference</P><P></P><P>Celambarasan</P></BODY></HTML> Tue, 17 Apr 2012 16:11:27 GMT https://community.qlik.com/t5/QlikView/What-datatype-to-make-calculation/m-p/355633#M1174431 CELAMBARASAN 2012-04-17T16:11:27Z