topic Re: Re: SumProduct equivalent function in Qlikview in QlikView https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652011#M238369 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find attached application in which i have modified the expression to achieve the expected output.</P><P></P><P>Regards,</P><P></P><P>Jatin kolhe.</P></BODY></HTML> Mon, 11 Aug 2014 06:17:41 GMT 2014-08-11T06:17:41Z SumProduct equivalent function in Qlikview https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652008#M238366 <HTML><HEAD></HEAD><BODY><P> I need to calculate the overall average cost for a given dimension (entire data set). The enclosed EXCEL and QVW is a complete statement of what I wish to achieve and the way I have approached the solution.</P><P></P><P><STRONG>Forecast drivers</STRONG> (Straight table) has <SPAN style="color: #575757; text-decoration: underline;">InputSum fields</SPAN> needed for forecasting based on various scenarios. This value is used to the expression in the second straigt table <STRONG>Forecast Analysis</STRONG>. I am expecting 45,333 as the Overall Opening ARC and simialrly 45,342 as the Overall Joiner ARC.</P><P></P><P>Please help solve this issue or suggest alternate approach.@</P><P></P><P>Advance thanks.</P></BODY></HTML> Sun, 10 Aug 2014 11:12:04 GMT https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652008#M238366 2014-08-10T11:12:04Z Re: SumProduct equivalent function in Qlikview https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652009#M238367 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be like this.</P><P>Make sure your joiner ARC calculation is correct.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 10 Aug 2014 11:25:57 GMT https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652009#M238367 ashfaq_haseeb 2014-08-10T11:25:57Z Re: SumProduct equivalent function in Qlikview https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652010#M238368 <HTML><HEAD></HEAD><BODY><P>Ashfaq, thanks for attempting. While Opening ARC gets fixed by slightly modifying the expression, we still have an issue with the expression for Joiner ARC. The expression change [Opening ARC] <SPAN style="font-size: 8pt;"> * (1 + sum(SimJoinerOpeningARC)) applies an 89% increase on the Opening ARC of 45,333. <SPAN style="text-decoration: underline;">That is not correct</SPAN>.</SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">When we set Total Mode as Expression Total, it takes the Total of SimJoinerOpeningARC from the Forecast Drivers table and multiplies it with the column total of Opening ARC (i.e 45,333). We need to overcome this precise issue.</SPAN></P><P> </P><P><BR /> </P></BODY></HTML> Sun, 10 Aug 2014 15:13:49 GMT https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652010#M238368 2014-08-10T15:13:49Z Re: Re: SumProduct equivalent function in Qlikview https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652011#M238369 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find attached application in which i have modified the expression to achieve the expected output.</P><P></P><P>Regards,</P><P></P><P>Jatin kolhe.</P></BODY></HTML> Mon, 11 Aug 2014 06:17:41 GMT https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652011#M238369 2014-08-11T06:17:41Z Re: Re: Re: SumProduct equivalent function in Qlikview https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652012#M238370 <HTML><HEAD></HEAD><BODY><P>Hi Sir,</P><P>Find the attached</P></BODY></HTML> Mon, 11 Aug 2014 06:55:47 GMT https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652012#M238370 Anonymous 2014-08-11T06:55:47Z Re: SumProduct equivalent function in Qlikview https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652013#M238371 <HTML><HEAD></HEAD><BODY><P><BR />Thanks Jatin. Wonderful</P><P></P><P>Whenever you have count for HC using it with Aggregation function seems to be the right way of implementation.</P></BODY></HTML> Mon, 11 Aug 2014 07:44:23 GMT https://community.qlik.com/t5/QlikView/SumProduct-equivalent-function-in-Qlikview/m-p/652013#M238371 2014-08-11T07:44:23Z