topic Re: Integer in format date in QlikView https://community.qlik.com/t5/QlikView/Integer-in-format-date/m-p/604607#M546826 <HTML><HEAD></HEAD><BODY><P>May be your formula will be something like this</P><P>Num(Text(Interval(TotalTime, 'h'))) / TotalTicket</P><P></P><P>TotalTime is <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </SPAN><SPAN class="hps" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">total</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </SPAN><SPAN class="hps" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">time</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </SPAN><SPAN class="hps" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">of</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </SPAN><SPAN class="hps" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">taking charge</SPAN> - Difference between 2 datetime.</P></BODY></HTML> Wed, 19 Feb 2014 09:14:23 GMT CELAMBARASAN 2014-02-19T09:14:23Z Integer in format date https://community.qlik.com/t5/QlikView/Integer-in-format-date/m-p/604605#M546824 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Hello to all</SPAN> <BR /><BR /><SPAN class="hps">I have</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">calculated</SPAN> <SPAN class="hps">field</SPAN> <SPAN class="hps">as the ratio of</SPAN> <SPAN class="hps">total</SPAN> <SPAN class="hps">ticket and</SPAN> <SPAN class="hps">the total</SPAN> <SPAN class="hps">time</SPAN> <SPAN class="hps">taken</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">resolution.</SPAN> <BR /><BR /><SPAN class="hps">the result is</SPAN> <SPAN class="hps">an integer that</SPAN> <SPAN class="hps">should</SPAN> <SPAN class="hps">express in</SPAN> <SPAN class="hps">hours to have</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">mean time to resolution</SPAN><SPAN>.</SPAN> <BR /><BR /><SPAN class="hps">would know</SPAN> <SPAN class="hps">someone</SPAN> <SPAN class="hps">help me out</SPAN> <BR /><BR /><SPAN class="hps">For example,</SPAN> <SPAN class="hps">the ratio between the</SPAN> <SPAN class="hps">total</SPAN> <SPAN class="hps">time</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">taking charge</SPAN> <SPAN class="hps">and the total</SPAN> <SPAN class="hps">ticket</SPAN> <SPAN class="hps">the result is</SPAN> <SPAN class="hps">1.3</SPAN> <BR /><BR /><SPAN class="hps">tell me</SPAN> <SPAN class="hps">someone</SPAN> <SPAN class="hps">would know</SPAN> <SPAN class="hps">how to express</SPAN> <SPAN class="hps">this</SPAN> <SPAN class="hps">value in hours</SPAN><SPAN>?</SPAN> <BR /><BR /><SPAN class="hps">thanks</SPAN> <BR /><BR /><SPAN class="hps">Andrea</SPAN></SPAN></P></BODY></HTML> Wed, 19 Feb 2014 09:04:36 GMT https://community.qlik.com/t5/QlikView/Integer-in-format-date/m-p/604605#M546824 warrentk80 2014-02-19T09:04:36Z Re: Integer in format date https://community.qlik.com/t5/QlikView/Integer-in-format-date/m-p/604606#M546825 <HTML><HEAD></HEAD><BODY><P>What is your expression to get this ratio?</P></BODY></HTML> Wed, 19 Feb 2014 09:12:09 GMT https://community.qlik.com/t5/QlikView/Integer-in-format-date/m-p/604606#M546825 MK_QSL 2014-02-19T09:12:09Z Re: Integer in format date https://community.qlik.com/t5/QlikView/Integer-in-format-date/m-p/604607#M546826 <HTML><HEAD></HEAD><BODY><P>May be your formula will be something like this</P><P>Num(Text(Interval(TotalTime, 'h'))) / TotalTicket</P><P></P><P>TotalTime is <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </SPAN><SPAN class="hps" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">total</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </SPAN><SPAN class="hps" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">time</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </SPAN><SPAN class="hps" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">of</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </SPAN><SPAN class="hps" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">taking charge</SPAN> - Difference between 2 datetime.</P></BODY></HTML> Wed, 19 Feb 2014 09:14:23 GMT https://community.qlik.com/t5/QlikView/Integer-in-format-date/m-p/604607#M546826 CELAMBARASAN 2014-02-19T09:14:23Z