topic Re: #1 KPI with &quot;SUMPRODUCT&quot; Formula in App Development https://community.qlik.com/t5/App-Development/1-KPI-with-quot-SUMPRODUCT-quot-Formula/m-p/1455950#M35826 <HTML><HEAD></HEAD><BODY><P>Thank you SKhan for your reply. </P><P>I had reattached again. Happy New Year!</P></BODY></HTML> Fri, 29 Dec 2017 01:05:55 GMT Anonymous 2017-12-29T01:05:55Z #1 KPI with "SUMPRODUCT" Formula https://community.qlik.com/t5/App-Development/1-KPI-with-quot-SUMPRODUCT-quot-Formula/m-p/1455948#M35824 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I would like to create a #1 KPI to show Monthly Average Number as in the <SPAN style="; color: #0000ff;"><STRONG>blue box</STRONG></SPAN> in the print screen as well as a Yearly Average Number in the <SPAN style="color: #ff0000;"><STRONG>Red Box</STRONG></SPAN>.</P><P><IMG __jive_id="188316" alt="Print screen.PNG" class="jive-image image-1" src="/legacyfs/online/188316_Print screen.PNG" style="width: 620px; height: 89px;" /></P><P>Actual calculation formula are as attached in the excel.</P><P></P><P>Thank you very much in advance for your assistance!</P><P>Cheers and Happy New Year!</P><P></P><P>訊息由此人編輯：Woon Han Yap</P></BODY></HTML> Thu, 28 Dec 2017 00:47:47 GMT https://community.qlik.com/t5/App-Development/1-KPI-with-quot-SUMPRODUCT-quot-Formula/m-p/1455948#M35824 Anonymous 2017-12-28T00:47:47Z Re: #1 KPI with "SUMPRODUCT" Formula https://community.qlik.com/t5/App-Development/1-KPI-with-quot-SUMPRODUCT-quot-Formula/m-p/1455949#M35825 <HTML><HEAD></HEAD><BODY><P>You are missing the attachment with your question.</P></BODY></HTML> Thu, 28 Dec 2017 14:00:42 GMT https://community.qlik.com/t5/App-Development/1-KPI-with-quot-SUMPRODUCT-quot-Formula/m-p/1455949#M35825 MK9885 2017-12-28T14:00:42Z Re: #1 KPI with "SUMPRODUCT" Formula https://community.qlik.com/t5/App-Development/1-KPI-with-quot-SUMPRODUCT-quot-Formula/m-p/1455950#M35826 <HTML><HEAD></HEAD><BODY><P>Thank you SKhan for your reply. </P><P>I had reattached again. Happy New Year!</P></BODY></HTML> Fri, 29 Dec 2017 01:05:55 GMT https://community.qlik.com/t5/App-Development/1-KPI-with-quot-SUMPRODUCT-quot-Formula/m-p/1455950#M35826 Anonymous 2017-12-29T01:05:55Z