topic Total Sum in QlikView https://community.qlik.com/t5/QlikView/Total-Sum/m-p/457153#M170665 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm trying to perform a total sum( without a dimension) on a relatively simple chart/table, but I am unable to show the SUM at the TOP.</P><P></P><P>I have a pivot table ( chart), which has no dimension and I'm struggling to create a sum total at the top of the expressions?</P><P>How can I achieve this?</P><P>The sum at the TOP should be 4. </P><P>How can I acheive this?</P><P></P><P>Attached is my app.</P><P></P><P>Many thanks</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 10 Jun 2013 13:35:40 GMT 2013-06-10T13:35:40Z Total Sum https://community.qlik.com/t5/QlikView/Total-Sum/m-p/457153#M170665 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm trying to perform a total sum( without a dimension) on a relatively simple chart/table, but I am unable to show the SUM at the TOP.</P><P></P><P>I have a pivot table ( chart), which has no dimension and I'm struggling to create a sum total at the top of the expressions?</P><P>How can I achieve this?</P><P>The sum at the TOP should be 4. </P><P>How can I acheive this?</P><P></P><P>Attached is my app.</P><P></P><P>Many thanks</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 10 Jun 2013 13:35:40 GMT https://community.qlik.com/t5/QlikView/Total-Sum/m-p/457153#M170665 2013-06-10T13:35:40Z Re: Total Sum https://community.qlik.com/t5/QlikView/Total-Sum/m-p/457154#M170666 <HTML><HEAD></HEAD><BODY><P>What you can do is add another expression an promote that to the top. The expression would be: <EM>rangesum([Awaiting Customer Feedback],[Awaiting Sales Feedback],[Pending Withdrawal],[No Action Status])</EM></P></BODY></HTML> Mon, 10 Jun 2013 13:41:32 GMT https://community.qlik.com/t5/QlikView/Total-Sum/m-p/457154#M170666 Gysbert_Wassenaar 2013-06-10T13:41:32Z Re: Total Sum https://community.qlik.com/t5/QlikView/Total-Sum/m-p/457155#M170667 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I believe you only get it in the title. Look at the attachment.</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>Rebeca</P></BODY></HTML> Mon, 10 Jun 2013 13:46:37 GMT https://community.qlik.com/t5/QlikView/Total-Sum/m-p/457155#M170667 2013-06-10T13:46:37Z