topic 3 month moving average Market share in QlikView https://community.qlik.com/t5/QlikView/3-month-moving-average-Market-share/m-p/112211#M603699 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Can anyone help me in calculating Market share for 3 month moving average?</P><P></P><P>I am using a formula something like below,</P><P>RangeAvg(Above(sum(Value),0,3)/<SPAN style="font-size: 13.3333px;">RangeAvg(Above(sum(Total Value),0,3)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Regards,</SPAN></P><P><SPAN style="font-size: 13.3333px;">Leni Balakrishnan</SPAN></P></BODY></HTML> Mon, 10 Sep 2018 13:53:53 GMT leni_harishwara 2018-09-10T13:53:53Z 3 month moving average Market share https://community.qlik.com/t5/QlikView/3-month-moving-average-Market-share/m-p/112211#M603699 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Can anyone help me in calculating Market share for 3 month moving average?</P><P></P><P>I am using a formula something like below,</P><P>RangeAvg(Above(sum(Value),0,3)/<SPAN style="font-size: 13.3333px;">RangeAvg(Above(sum(Total Value),0,3)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Regards,</SPAN></P><P><SPAN style="font-size: 13.3333px;">Leni Balakrishnan</SPAN></P></BODY></HTML> Mon, 10 Sep 2018 13:53:53 GMT https://community.qlik.com/t5/QlikView/3-month-moving-average-Market-share/m-p/112211#M603699 leni_harishwara 2018-09-10T13:53:53Z