topic Re: RangeSum is showing 0 instead of value in QlikView https://community.qlik.com/t5/QlikView/RangeSum-is-showing-0-instead-of-value/m-p/1417616#M811329 <HTML><HEAD></HEAD><BODY><P>This works correctly, cheers guys!</P></BODY></HTML> Mon, 09 Oct 2017 20:56:38 GMT Anonymous 2017-10-09T20:56:38Z RangeSum is showing 0 instead of value https://community.qlik.com/t5/QlikView/RangeSum-is-showing-0-instead-of-value/m-p/1417612#M811325 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am using this expression to get the Total value of the fields but I get 0 value anyway and I want to show the full value, in this case: 2</P><P>FieldA has value 2, FieldB is null.</P><P></P><P>Expression: RangeSum([FieldA]+[<SPAN style="font-size: 13.3333px;">FieldB</SPAN>])</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">FieldA</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ffffff; font-size: 13.3333px; text-align: center; background-color: #6690bc;">FieldB</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Total</STRONG></TH></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">0</TD></TR></TBODY></TABLE><P></P><P>Is there any trick here? I also tried with sum/count.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/RangeSum-is-showing-0-instead-of-value/m-p/1417612#M811325 Anonymous 2020-11-25T16:16:04Z Re: RangeSum is showing 0 instead of value https://community.qlik.com/t5/QlikView/RangeSum-is-showing-0-instead-of-value/m-p/1417613#M811326 <HTML><HEAD></HEAD><BODY><P>sum(FieldA)+sum(FieldB)</P><P></P><P>hope this helps</P></BODY></HTML> Mon, 09 Oct 2017 19:51:26 GMT https://community.qlik.com/t5/QlikView/RangeSum-is-showing-0-instead-of-value/m-p/1417613#M811326 Frank_Hartmann 2017-10-09T19:51:26Z Re: RangeSum is showing 0 instead of value https://community.qlik.com/t5/QlikView/RangeSum-is-showing-0-instead-of-value/m-p/1417614#M811327 <HTML><HEAD></HEAD><BODY><P>Use comma separated two arguments:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> RangeSum(<STRONG>[FieldA], [</STRONG></SPAN><STRONG style="color: #3d3d3d; font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">FieldB</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>]</STRONG>)</SPAN></P></BODY></HTML> Mon, 09 Oct 2017 19:56:07 GMT https://community.qlik.com/t5/QlikView/RangeSum-is-showing-0-instead-of-value/m-p/1417614#M811327 swuehl 2017-10-09T19:56:07Z Re: RangeSum is showing 0 instead of value https://community.qlik.com/t5/QlikView/RangeSum-is-showing-0-instead-of-value/m-p/1417615#M811328 <HTML><HEAD></HEAD><BODY><P>This works correctly</P></BODY></HTML> Mon, 09 Oct 2017 20:56:19 GMT https://community.qlik.com/t5/QlikView/RangeSum-is-showing-0-instead-of-value/m-p/1417615#M811328 Anonymous 2017-10-09T20:56:19Z Re: RangeSum is showing 0 instead of value https://community.qlik.com/t5/QlikView/RangeSum-is-showing-0-instead-of-value/m-p/1417616#M811329 <HTML><HEAD></HEAD><BODY><P>This works correctly, cheers guys!</P></BODY></HTML> Mon, 09 Oct 2017 20:56:38 GMT https://community.qlik.com/t5/QlikView/RangeSum-is-showing-0-instead-of-value/m-p/1417616#M811329 Anonymous 2017-10-09T20:56:38Z