topic Re: Rangesum function error in QlikView https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438429#M431837 <HTML><HEAD></HEAD><BODY><P>second graph</P></BODY></HTML> Tue, 22 Aug 2017 08:38:04 GMT hemeshreddy 2017-08-22T08:38:04Z Rangesum function error https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438427#M431835 <HTML><HEAD></HEAD><BODY><P>Hi guys PFA,</P><P></P><P>In this for year 2016 i am getting wrong accumulated sum</P><P></P><P></P><P>Regards,</P><P>Hemesh</P></BODY></HTML> Mon, 21 Aug 2017 12:18:26 GMT https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438427#M431835 hemeshreddy 2017-08-21T12:18:26Z Re: Rangesum function error https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438428#M431836 <HTML><HEAD></HEAD><BODY><P>Which graph we need to look? There is 2 graphs</P></BODY></HTML> Tue, 22 Aug 2017 08:36:46 GMT https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438428#M431836 Anil_Babu_Samineni 2017-08-22T08:36:46Z Re: Rangesum function error https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438429#M431837 <HTML><HEAD></HEAD><BODY><P>second graph</P></BODY></HTML> Tue, 22 Aug 2017 08:38:04 GMT https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438429#M431837 hemeshreddy 2017-08-22T08:38:04Z Re: Rangesum function error https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438430#M431838 <HTML><HEAD></HEAD><BODY><P>What's wrong here?</P><P></P><P>I used this? </P><P><STRONG>RangeSum(Above(Sum(Sale),0,RowNo(TOTAL)))</STRONG></P><P></P><P>And enable Full accumulation radio button</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174191_Capture.PNG" style="height: 385px; width: 620px;" /></P></BODY></HTML> Tue, 22 Aug 2017 08:39:51 GMT https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438430#M431838 Anil_Babu_Samineni 2017-08-22T08:39:51Z Re: Rangesum function error https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438431#M431839 <HTML><HEAD></HEAD><BODY><P>i need without checking the full accumulation radio button.</P></BODY></HTML> Tue, 22 Aug 2017 08:43:47 GMT https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438431#M431839 hemeshreddy 2017-08-22T08:43:47Z Re: Rangesum function error https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438432#M431840 <HTML><HEAD></HEAD><BODY><P>Use this?</P><P></P><P><STRONG>RangeSum(above(TOTAL sum(Sale),0,RowNo(TOTAL)))</STRONG></P></BODY></HTML> Tue, 22 Aug 2017 08:52:22 GMT https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438432#M431840 Anil_Babu_Samineni 2017-08-22T08:52:22Z Re: Rangesum function error https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438433#M431841 <HTML><HEAD></HEAD><BODY><P>it is giving the correct result </P><P></P><P>May i know what is wrong in that expression which i written</P></BODY></HTML> Tue, 22 Aug 2017 09:03:02 GMT https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438433#M431841 hemeshreddy 2017-08-22T09:03:02Z Re: Rangesum function error https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438434#M431842 <HTML><HEAD></HEAD><BODY><P>May be TOTAL Keyword missing, And one blog is there for the same. You can read that blog to understand whole</P></BODY></HTML> Tue, 22 Aug 2017 09:05:46 GMT https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438434#M431842 Anil_Babu_Samineni 2017-08-22T09:05:46Z Re: Rangesum function error https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438435#M431843 <HTML><HEAD></HEAD><BODY><P>after giving Total key word also it's giving wrong result,</P><P></P><P>can u share me the blog URL</P></BODY></HTML> Tue, 22 Aug 2017 09:12:22 GMT https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438435#M431843 hemeshreddy 2017-08-22T09:12:22Z Re: Rangesum function error https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438436#M431844 <HTML><HEAD></HEAD><BODY><P>Read this?</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/4160">What does the TOTAL qualifier do?</A></P><P></P><P>And, FFor explanation in my way is TOTAL keyword can store the TOTAL sales and then we are displaying to each row level until RowNo(TOTAL) -- How many rows?</P><P></P><P>And read this too <A href="https://community.qlik.com/docs/DOC-8242">Missing Manual - Above() and Below()</A></P></BODY></HTML> Tue, 22 Aug 2017 09:16:43 GMT https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438436#M431844 Anil_Babu_Samineni 2017-08-22T09:16:43Z Re: Rangesum function error https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438437#M431845 <HTML><HEAD></HEAD><BODY><P>thank u anil</P></BODY></HTML> Tue, 22 Aug 2017 09:45:40 GMT https://community.qlik.com/t5/QlikView/Rangesum-function-error/m-p/1438437#M431845 hemeshreddy 2017-08-22T09:45:40Z