topic vMAPE Calculation in QlikView https://community.qlik.com/t5/QlikView/vMAPE-Calculation/m-p/723591#M259626 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hi,</SPAN></P><P></P><P><SPAN style="color: #000000;">Please find the attached QlikView document. Scenario is like this :</SPAN></P><P></P><P><SPAN style="color: #000000;">Selection Parameter - <STRONG>Year--&gt;2014 --&gt; OGC --&gt; JAN --&gt; Type --&gt; Uncertified</STRONG></SPAN></P><P></P><P><SPAN style="color: #000000;">Down side Group wise vMAPE % and Accuracy % Chart is available, So please select Meeles from there.</SPAN></P><P></P><P><SPAN style="color: #000000;">Now Export the Data to xls of Upper Chart, i.e - (Plan v/s Actual) &amp; VMAPE-Category wise. </SPAN></P><P></P><P><SPAN style="color: #000000;">Now - Make a calculation in xls = Sum(VMAPE) --&gt; 0.75 and Sum(Actual) --&gt; 4.70, Then<STRONG> (Sum(VMAPE) / Sum(Actual)) * 100</STRONG> = <STRONG>(0.75 / 4.70)</STRONG> = 16.03</SPAN></P><P></P><P><SPAN style="color: #000000;">The same figure I need in down side graph, i.e Group wise vMAPE % and Accuracy %. Here calculation is like = What have formula is upper side for vMAPE, <STRONG>(vMAPE / Sum(Actual)) * 100</STRONG>.</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Field Name - Actual is SALES_QTY and&nbsp; PLAN = SOP_cts</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Thanks.</SPAN></P></BODY></HTML> Sat, 06 Sep 2014 06:14:58 GMT sona_sa 2014-09-06T06:14:58Z vMAPE Calculation https://community.qlik.com/t5/QlikView/vMAPE-Calculation/m-p/723591#M259626 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hi,</SPAN></P><P></P><P><SPAN style="color: #000000;">Please find the attached QlikView document. Scenario is like this :</SPAN></P><P></P><P><SPAN style="color: #000000;">Selection Parameter - <STRONG>Year--&gt;2014 --&gt; OGC --&gt; JAN --&gt; Type --&gt; Uncertified</STRONG></SPAN></P><P></P><P><SPAN style="color: #000000;">Down side Group wise vMAPE % and Accuracy % Chart is available, So please select Meeles from there.</SPAN></P><P></P><P><SPAN style="color: #000000;">Now Export the Data to xls of Upper Chart, i.e - (Plan v/s Actual) &amp; VMAPE-Category wise. </SPAN></P><P></P><P><SPAN style="color: #000000;">Now - Make a calculation in xls = Sum(VMAPE) --&gt; 0.75 and Sum(Actual) --&gt; 4.70, Then<STRONG> (Sum(VMAPE) / Sum(Actual)) * 100</STRONG> = <STRONG>(0.75 / 4.70)</STRONG> = 16.03</SPAN></P><P></P><P><SPAN style="color: #000000;">The same figure I need in down side graph, i.e Group wise vMAPE % and Accuracy %. Here calculation is like = What have formula is upper side for vMAPE, <STRONG>(vMAPE / Sum(Actual)) * 100</STRONG>.</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Field Name - Actual is SALES_QTY and&nbsp; PLAN = SOP_cts</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Thanks.</SPAN></P></BODY></HTML> Sat, 06 Sep 2014 06:14:58 GMT https://community.qlik.com/t5/QlikView/vMAPE-Calculation/m-p/723591#M259626 sona_sa 2014-09-06T06:14:58Z Re: vMAPE Calculation https://community.qlik.com/t5/QlikView/vMAPE-Calculation/m-p/723592#M259627 <HTML><HEAD></HEAD><BODY><P>Can anybody help me on the posted discussion. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sat, 06 Sep 2014 06:52:03 GMT https://community.qlik.com/t5/QlikView/vMAPE-Calculation/m-p/723592#M259627 sona_sa 2014-09-06T06:52:03Z