topic Re: RANGESUM() function ? in QlikView https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677263#M245706 <HTML><HEAD></HEAD><BODY><P>8</P><P></P><P>RangeSum will add all numeric value and all non-numeric will be considered as 0</P></BODY></HTML> Thu, 11 Sep 2014 11:28:37 GMT MK_QSL 2014-09-11T11:28:37Z RANGESUM() function ? https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677262#M245705 <HTML><HEAD></HEAD><BODY><P>Bonjour ; </P><P></P><P>What is the Result of : </P><TABLE class="ct_qtable_radio ct_qtable_radio_top ct_qtable" style="margin-bottom: 1em; border: 0px; font-family: Arial;"><TBODY><TR><TD class="ct_td_qtext ct_td_qtext_top" style="padding-bottom: 0.5em;"><SPAN class="ct_qtext ct_qtext_top" style="color: #000000; font-size: 12pt; font-weight: bold;">RANGESUM(1, 2, 'abc', NULL(), 5) </SPAN></TD></TR><TR><TD class="ct_td_control ct_td_control_radio ct_td_control_top" width="100%"><SPAN class="ct_control_radio ct_control_radio_top ct_control"></SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 11 Sep 2014 11:27:22 GMT https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677262#M245705 2014-09-11T11:27:22Z Re: RANGESUM() function ? https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677263#M245706 <HTML><HEAD></HEAD><BODY><P>8</P><P></P><P>RangeSum will add all numeric value and all non-numeric will be considered as 0</P></BODY></HTML> Thu, 11 Sep 2014 11:28:37 GMT https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677263#M245706 MK_QSL 2014-09-11T11:28:37Z Re: RANGESUM() function ? https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677264#M245707 <HTML><HEAD></HEAD><BODY><P>8 would be the answer</P></BODY></HTML> Thu, 11 Sep 2014 11:29:27 GMT https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677264#M245707 senpradip007 2014-09-11T11:29:27Z Re: RANGESUM() function ? https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677266#M245709 <HTML><HEAD></HEAD><BODY><P>Result is 8 </P></BODY></HTML> Thu, 11 Sep 2014 11:33:21 GMT https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677266#M245709 jvishnuram 2014-09-11T11:33:21Z Re: RANGESUM() function ? https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677267#M245710 <HTML><HEAD></HEAD><BODY><P>Helpful <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 06 Oct 2015 11:29:30 GMT https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677267#M245710 2015-10-06T11:29:30Z Re: RANGESUM() function ? https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677268#M245711 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><SPAN class="Bold">Rangesum</SPAN> will treat all non-numeric values as 0. </P><P></P><TABLE cellspacing="0" class="TableStyle-LeftBold" style="margin-right: auto;"><TBODY><TR class="Body-Body1"><TD class="BodyE-Column1-Body1">rangesum (1,2,4)</TD><TD class="BodyD-Column2-Body1">returns 7</TD></TR><TR class="Body-Body1"><TD class="BodyE-Column1-Body1">rangesum (1,'xyz')</TD><TD class="BodyD-Column2-Body1">returns 1</TD></TR><TR class="Body-Body1"><TD class="BodyE-Column1-Body1">rangesum (null( ))</TD><TD class="BodyD-Column2-Body1">returns 0</TD></TR><TR class="Body-Body1"><TD class="BodyE-Column1-Body1">rangesum (above(count(x),-1,3))</TD><TD class="BodyD-Column2-Body1">returns the sum of the three results of the <SPAN class="Bold">count(x)</SPAN> function evaluated on the row below the current row, the current row and the row above the current row. </TD></TR></TBODY></TABLE></BODY></HTML> Tue, 06 Oct 2015 11:59:51 GMT https://community.qlik.com/t5/QlikView/RANGESUM-function/m-p/677268#M245711 2015-10-06T11:59:51Z