topic Wrong total with Time in QlikView https://community.qlik.com/t5/QlikView/Wrong-total-with-Time/m-p/181675#M47595 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a problem with the Total in a pivot table when I want to sum Time. As you can see in the attached pic the Total is not the whole sum of the overlying rows.</P><P></P><P>How can I get the right sum in the Total? I use Time(<I style="mso-bidi-font-style: normal;">Duration</I>) in the scrip to get the right timestamp.</P></BODY></HTML> Tue, 16 Mar 2010 13:38:20 GMT 2010-03-16T13:38:20Z Wrong total with Time https://community.qlik.com/t5/QlikView/Wrong-total-with-Time/m-p/181675#M47595 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a problem with the Total in a pivot table when I want to sum Time. As you can see in the attached pic the Total is not the whole sum of the overlying rows.</P><P></P><P>How can I get the right sum in the Total? I use Time(<I style="mso-bidi-font-style: normal;">Duration</I>) in the scrip to get the right timestamp.</P></BODY></HTML> Tue, 16 Mar 2010 13:38:20 GMT https://community.qlik.com/t5/QlikView/Wrong-total-with-Time/m-p/181675#M47595 2010-03-16T13:38:20Z Wrong total with Time https://community.qlik.com/t5/QlikView/Wrong-total-with-Time/m-p/181676#M47596 <HTML><HEAD></HEAD><BODY><P>Hi, Johanna,</P><P>in <STRONG>Chart Properties</STRONG> -&gt; <STRONG>Expressions</STRONG> tab check <STRONG>Total Mode</STRONG> as <STRONG>Sum of Rows</STRONG>. I guess that is what you are looking for.</P><P>Goog luck,</P><P>Justinas</P></BODY></HTML> Tue, 16 Mar 2010 13:42:25 GMT https://community.qlik.com/t5/QlikView/Wrong-total-with-Time/m-p/181676#M47596 justinasp 2010-03-16T13:42:25Z Wrong total with Time https://community.qlik.com/t5/QlikView/Wrong-total-with-Time/m-p/181677#M47597 <HTML><HEAD></HEAD><BODY><P>Your duration column has Number format Time. It must be formatted as "Interval" to show a value greater than 24 hours.</P><P>-Rob</P></BODY></HTML> Wed, 17 Mar 2010 08:10:10 GMT https://community.qlik.com/t5/QlikView/Wrong-total-with-Time/m-p/181677#M47597 rwunderlich 2010-03-17T08:10:10Z