topic Re: help me to wirite set expression in QlikView https://community.qlik.com/t5/QlikView/help-me-to-wirite-set-expression/m-p/1439688#M611349 <HTML><HEAD></HEAD><BODY><P>If I mention total in front of sum is working. may I know the reason for this?</P><P></P><P>rangesum(above(total sum(Amount),0,3))</P></BODY></HTML> Tue, 24 Oct 2017 10:50:59 GMT Anonymous 2017-10-24T10:50:59Z help me to wirite set expression https://community.qlik.com/t5/QlikView/help-me-to-wirite-set-expression/m-p/1439685#M611346 <HTML><HEAD></HEAD><BODY><P>Hi I am new to Qlikview.</P><P></P><P>How to calculate past 3 months total sales in strightable for each month.</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="149" style="border: 1px solid #000000; border-image: none; width: 392px; height: 112px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Month</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">Dec</TD><TD style="padding: 2px;">5000</TD></TR><TR><TD style="padding: 2px;">Jan</TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;">Feb</TD><TD style="padding: 2px;">700</TD></TR><TR><TD style="padding: 2px;">Mar</TD><TD style="padding: 2px;">300</TD></TR><TR><TD style="padding: 2px;">Apr</TD><TD style="padding: 2px;">400</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks &amp; Regards</P><P>Swathi</P></BODY></HTML> Thu, 12 Oct 2017 06:45:39 GMT https://community.qlik.com/t5/QlikView/help-me-to-wirite-set-expression/m-p/1439685#M611346 Anonymous 2017-10-12T06:45:39Z Re: help me to wirite set expression https://community.qlik.com/t5/QlikView/help-me-to-wirite-set-expression/m-p/1439686#M611347 <HTML><HEAD></HEAD><BODY><P>You have to order the dimension correctly first. </P><P>This will work after you sort: </P><P>RangeSum (</P><P>Above (Sum(Sales) , 0 , 3)</P><P>)</P></BODY></HTML> Thu, 12 Oct 2017 20:11:39 GMT https://community.qlik.com/t5/QlikView/help-me-to-wirite-set-expression/m-p/1439686#M611347 vkish16161 2017-10-12T20:11:39Z Re: help me to wirite set expression https://community.qlik.com/t5/QlikView/help-me-to-wirite-set-expression/m-p/1439687#M611348 <HTML><HEAD></HEAD><BODY><P>this can help </P><P></P><P><A href="https://community.qlikview.com/docs/DOC-4252" title="https://community.qlikview.com/docs/DOC-4252">Calculating rolling n-period totals, averages o... | Qlik Community</A></P></BODY></HTML> Thu, 12 Oct 2017 20:20:23 GMT https://community.qlik.com/t5/QlikView/help-me-to-wirite-set-expression/m-p/1439687#M611348 maxgro 2017-10-12T20:20:23Z Re: help me to wirite set expression https://community.qlik.com/t5/QlikView/help-me-to-wirite-set-expression/m-p/1439688#M611349 <HTML><HEAD></HEAD><BODY><P>If I mention total in front of sum is working. may I know the reason for this?</P><P></P><P>rangesum(above(total sum(Amount),0,3))</P></BODY></HTML> Tue, 24 Oct 2017 10:50:59 GMT https://community.qlik.com/t5/QlikView/help-me-to-wirite-set-expression/m-p/1439688#M611349 Anonymous 2017-10-24T10:50:59Z