topic Re: Stock turnover ratio ? in QlikView https://community.qlik.com/t5/QlikView/Stock-turnover-ratio/m-p/682957#M1066416 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Using rangesum u can solve ur expression like:</P><P></P><P><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: blue;">Sum(Stock Value)/((sum</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">( </SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: blue;">aggr</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">( </SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: blue;">rangesum</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">( </SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: blue;">above</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">( </SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: blue;">sum</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Stock Value</SPAN>),0,3) ),</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: maroon;">Month</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">))*3)/9)</SPAN></P><P><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">HTH</SPAN></P><P><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">Sushil<BR /></SPAN></P></BODY></HTML> Fri, 12 Sep 2014 06:40:19 GMT sushil353 2014-09-12T06:40:19Z Stock turnover ratio ? https://community.qlik.com/t5/QlikView/Stock-turnover-ratio/m-p/682956#M1066415 <HTML><HEAD></HEAD><BODY><TABLE height="24" style="width: 663px; height: 1px;" width="661"><TBODY><TR><TD>Stock Turnover Ratio</TD><TD>Sum(Stock Value)/((Previous 3 Months Sales *3)/9)</TD></TR></TBODY></TABLE><P></P><P>How to convert this into qlikview formula ?</P></BODY></HTML> Fri, 12 Sep 2014 06:34:52 GMT https://community.qlik.com/t5/QlikView/Stock-turnover-ratio/m-p/682956#M1066415 2014-09-12T06:34:52Z Re: Stock turnover ratio ? https://community.qlik.com/t5/QlikView/Stock-turnover-ratio/m-p/682957#M1066416 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Using rangesum u can solve ur expression like:</P><P></P><P><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: blue;">Sum(Stock Value)/((sum</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">( </SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: blue;">aggr</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">( </SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: blue;">rangesum</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">( </SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: blue;">above</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">( </SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: blue;">sum</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Stock Value</SPAN>),0,3) ),</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: maroon;">Month</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">))*3)/9)</SPAN></P><P><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">HTH</SPAN></P><P><SPAN style="font-size: 10pt; font-family: 'Courier New'; background-color: #f5faf0; color: black;">Sushil<BR /></SPAN></P></BODY></HTML> Fri, 12 Sep 2014 06:40:19 GMT https://community.qlik.com/t5/QlikView/Stock-turnover-ratio/m-p/682957#M1066416 sushil353 2014-09-12T06:40:19Z