topic Calculate difference between two n-array products for scatter chart expression in QlikView https://community.qlik.com/t5/QlikView/Calculate-difference-between-two-n-array-products-for-scatter/m-p/440473#M560555 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I need help for an expression:</P><P></P><P>HOW TO: Calculate difference between two n-array products, where variable <STRONG>n</STRONG> depends on user current selection.</P><P><SPAN style="font-size: 10pt;">I load data from Excel tables. </SPAN></P><P></P><P>For a list of assets I have quarterly performances</P><P>asset performance: <STRONG>Ai</STRONG> (i=1 ... 4)</P><P>and it's respective benchmark's performance: <STRONG>Bi</STRONG> (i=1 ... 4)&nbsp;&nbsp;&nbsp; </P><P></P><P>I want it to calculate the the following formula, which I failed to translate into "Qlikview" expression language (I'm a beginner)</P><P></P><P><SPAN style="font-size: 10pt;">Outperformance:&nbsp; i=1<SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff; font-size: 18pt;"><SPAN style="font-size: 14pt;">∏</SPAN><SPAN style="font-size: 10pt;">4(Ai) - </SPAN></SPAN></SPAN><SPAN style="font-size: 10pt;">i=1</SPAN><SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff; font-size: 18pt;"><SPAN style="font-size: 14pt;">∏</SPAN><SPAN style="font-size: 10pt;">4(Bi) </SPAN></SPAN></P><P></P><P>Here is sample data:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Asset</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Period</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG> Performance Fund</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Performance Benchmark</STRONG></SPAN></TH></TR><TR><TD>xxxx</TD><TD>Quarter 1</TD><TD style="text-align: center;"><P><SPAN style="font-size: 10pt;">1.03</SPAN></P></TD><TD style="text-align: center;">1.02</TD></TR><TR><TD>xxxx</TD><TD>Quarter 2</TD><TD style="text-align: center;">1.05</TD><TD style="text-align: center;">1.03</TD></TR><TR><TD>xxxx</TD><TD>Quarter 3</TD><TD style="text-align: center;">1.06</TD><TD style="text-align: center;">1.04</TD></TR><TR><TD><P>xxxx</P></TD><TD>Quarter 4</TD><TD style="text-align: center;">1.02</TD><TD style="text-align: center;">1.03</TD></TR><TR><TD><P>yyyy</P></TD><TD>Quarter 1</TD><TD>...</TD><TD>...</TD></TR><TR><TD>yyyy</TD><TD>Quarter 2</TD><TD>...</TD><TD>...</TD></TR><TR><TD>yyyy</TD><TD>...</TD><TD>...</TD><TD>...</TD></TR><TR><TD>yyyy</TD><TD>...</TD><TD>...</TD><TD>...</TD></TR></TBODY></TABLE><P></P><P><SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; font-size: 10pt; background-color: #ffffff;">Thanks very much in advanced for your help!</SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 8pt; background-color: #ffffff; font-family: Verdana, Arial, sans-serif;">BTW: <SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff;">"</SPAN><SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff;">∏</SPAN><SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff;">"</SPAN> ist the symbol for an n-array (x1 * x2 * x3 *...* xn), similar to the more often seen <SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff;">"</SPAN><SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff;">∑"</SPAN> for n-array summation (x1 + x2 + x3 .... xn)</SPAN></P><P></P><P>Message was edited by: s.spiess</P></BODY></HTML> Wed, 10 Apr 2013 09:37:08 GMT 2013-04-10T09:37:08Z Calculate difference between two n-array products for scatter chart expression https://community.qlik.com/t5/QlikView/Calculate-difference-between-two-n-array-products-for-scatter/m-p/440473#M560555 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I need help for an expression:</P><P></P><P>HOW TO: Calculate difference between two n-array products, where variable <STRONG>n</STRONG> depends on user current selection.</P><P><SPAN style="font-size: 10pt;">I load data from Excel tables. </SPAN></P><P></P><P>For a list of assets I have quarterly performances</P><P>asset performance: <STRONG>Ai</STRONG> (i=1 ... 4)</P><P>and it's respective benchmark's performance: <STRONG>Bi</STRONG> (i=1 ... 4)&nbsp;&nbsp;&nbsp; </P><P></P><P>I want it to calculate the the following formula, which I failed to translate into "Qlikview" expression language (I'm a beginner)</P><P></P><P><SPAN style="font-size: 10pt;">Outperformance:&nbsp; i=1<SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff; font-size: 18pt;"><SPAN style="font-size: 14pt;">∏</SPAN><SPAN style="font-size: 10pt;">4(Ai) - </SPAN></SPAN></SPAN><SPAN style="font-size: 10pt;">i=1</SPAN><SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff; font-size: 18pt;"><SPAN style="font-size: 14pt;">∏</SPAN><SPAN style="font-size: 10pt;">4(Bi) </SPAN></SPAN></P><P></P><P>Here is sample data:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Asset</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Period</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG> Performance Fund</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Performance Benchmark</STRONG></SPAN></TH></TR><TR><TD>xxxx</TD><TD>Quarter 1</TD><TD style="text-align: center;"><P><SPAN style="font-size: 10pt;">1.03</SPAN></P></TD><TD style="text-align: center;">1.02</TD></TR><TR><TD>xxxx</TD><TD>Quarter 2</TD><TD style="text-align: center;">1.05</TD><TD style="text-align: center;">1.03</TD></TR><TR><TD>xxxx</TD><TD>Quarter 3</TD><TD style="text-align: center;">1.06</TD><TD style="text-align: center;">1.04</TD></TR><TR><TD><P>xxxx</P></TD><TD>Quarter 4</TD><TD style="text-align: center;">1.02</TD><TD style="text-align: center;">1.03</TD></TR><TR><TD><P>yyyy</P></TD><TD>Quarter 1</TD><TD>...</TD><TD>...</TD></TR><TR><TD>yyyy</TD><TD>Quarter 2</TD><TD>...</TD><TD>...</TD></TR><TR><TD>yyyy</TD><TD>...</TD><TD>...</TD><TD>...</TD></TR><TR><TD>yyyy</TD><TD>...</TD><TD>...</TD><TD>...</TD></TR></TBODY></TABLE><P></P><P><SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; font-size: 10pt; background-color: #ffffff;">Thanks very much in advanced for your help!</SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 8pt; background-color: #ffffff; font-family: Verdana, Arial, sans-serif;">BTW: <SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff;">"</SPAN><SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff;">∏</SPAN><SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff;">"</SPAN> ist the symbol for an n-array (x1 * x2 * x3 *...* xn), similar to the more often seen <SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff;">"</SPAN><SPAN style="color: #000000; font-family: Verdana, Arial, sans-serif; background-color: #ffffff;">∑"</SPAN> for n-array summation (x1 + x2 + x3 .... xn)</SPAN></P><P></P><P>Message was edited by: s.spiess</P></BODY></HTML> Wed, 10 Apr 2013 09:37:08 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-between-two-n-array-products-for-scatter/m-p/440473#M560555 2013-04-10T09:37:08Z