topic Re: Wrong Total.... in QlikView https://community.qlik.com/t5/QlikView/Wrong-Total/m-p/756872#M1030090 <HTML><HEAD></HEAD><BODY><P>Hi Soha,</P><P></P><P>Qlikview is converting you time stamp to number format internally and making it sum.</P><P>That's why the result is wrong, convert the time stamp to sec or hr and get the sum out of it, this will give the sum of duration in seconds .</P><P>try like this</P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">sum(Interval</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">Time#</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Duration</SPAN>,'hh:mm:ss'),'ss') ) this will give duration sum in seconds</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">Hope this helps you <BR /></SPAN></P></BODY></HTML> Fri, 06 Feb 2015 09:35:01 GMT avinashelite 2015-02-06T09:35:01Z Wrong Total.... https://community.qlik.com/t5/QlikView/Wrong-Total/m-p/756869#M1030086 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have one field(Duration) which contains duration in HH:MM:SS format. I took one Text object and put Sum(Duration) expression and it will showing value. But I am not able to understand how Qlikview internally added these values. Its showing the wrong data. Can any one help me to understand this. Please find screenshot:</P><P><IMG alt="Time.jpg" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/77256_Time.jpg" style="height: auto;" /></P><P>Thanks.</P></BODY></HTML> Fri, 06 Feb 2015 08:54:00 GMT https://community.qlik.com/t5/QlikView/Wrong-Total/m-p/756869#M1030086 soha1902 2015-02-06T08:54:00Z Re: Wrong Total.... https://community.qlik.com/t5/QlikView/Wrong-Total/m-p/756870#M1030087 <HTML><HEAD></HEAD><BODY><P>Hi Soha,</P><P></P><P>Are you using any formatting? y wrapping your sum expression with a Time() function, which should reformat it, though your value looks extremely high to be a summed time expression!</P></BODY></HTML> Fri, 06 Feb 2015 08:55:17 GMT https://community.qlik.com/t5/QlikView/Wrong-Total/m-p/756870#M1030087 morganaaron 2015-02-06T08:55:17Z Re: Wrong Total.... https://community.qlik.com/t5/QlikView/Wrong-Total/m-p/756871#M1030088 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333330154419px;">can you share the application?</SPAN></P></BODY></HTML> Fri, 06 Feb 2015 09:24:42 GMT https://community.qlik.com/t5/QlikView/Wrong-Total/m-p/756871#M1030088 PradeepReddy 2015-02-06T09:24:42Z Re: Wrong Total.... https://community.qlik.com/t5/QlikView/Wrong-Total/m-p/756872#M1030090 <HTML><HEAD></HEAD><BODY><P>Hi Soha,</P><P></P><P>Qlikview is converting you time stamp to number format internally and making it sum.</P><P>That's why the result is wrong, convert the time stamp to sec or hr and get the sum out of it, this will give the sum of duration in seconds .</P><P>try like this</P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">sum(Interval</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">Time#</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Duration</SPAN>,'hh:mm:ss'),'ss') ) this will give duration sum in seconds</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">Hope this helps you <BR /></SPAN></P></BODY></HTML> Fri, 06 Feb 2015 09:35:01 GMT https://community.qlik.com/t5/QlikView/Wrong-Total/m-p/756872#M1030090 avinashelite 2015-02-06T09:35:01Z