topic Re: TOTAL function in QlikView https://community.qlik.com/t5/QlikView/TOTAL-function/m-p/1340930#M826925 <HTML><HEAD></HEAD><BODY><P>I didn't get your question, you meant to say this</P><P></P><P><STRONG>Sum(TOTAL &lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">office_cd, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Group</SPAN></SPAN>&gt; Sales)</STRONG></P></BODY></HTML> Thu, 06 Jul 2017 13:44:02 GMT Anil_Babu_Samineni 2017-07-06T13:44:02Z TOTAL function https://community.qlik.com/t5/QlikView/TOTAL-function/m-p/1340929#M826924 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is it possible to use the TOTAL function to return the overal total by two fields (office_cd and Group)?</P><P></P><P>Regards,</P><P>Daniel</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/TOTAL-function/m-p/1340929#M826924 danielnevitt 2020-11-25T16:16:04Z Re: TOTAL function https://community.qlik.com/t5/QlikView/TOTAL-function/m-p/1340930#M826925 <HTML><HEAD></HEAD><BODY><P>I didn't get your question, you meant to say this</P><P></P><P><STRONG>Sum(TOTAL &lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">office_cd, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Group</SPAN></SPAN>&gt; Sales)</STRONG></P></BODY></HTML> Thu, 06 Jul 2017 13:44:02 GMT https://community.qlik.com/t5/QlikView/TOTAL-function/m-p/1340930#M826925 Anil_Babu_Samineni 2017-07-06T13:44:02Z Re: TOTAL function https://community.qlik.com/t5/QlikView/TOTAL-function/m-p/1340931#M826926 <HTML><HEAD></HEAD><BODY><P>read this </P><P>you can write this also</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>sum(Sales)/</STRONG><STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">Sum(TOTAL &lt;<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px;">office_cd, <SPAN style="font-weight: inherit; font-style: inherit;">Group</SPAN></SPAN>&gt; Sales)</STRONG></SPAN></P><P><A href="https://community.qlik.com/thread/1371">Keywords : TOTAL, ALL &amp;amp; DISTINCT</A></P></BODY></HTML> Thu, 06 Jul 2017 13:47:08 GMT https://community.qlik.com/t5/QlikView/TOTAL-function/m-p/1340931#M826926 Chanty4u 2017-07-06T13:47:08Z