topic Norm calculation in QlikView https://community.qlik.com/t5/QlikView/Norm-calculation/m-p/431063#M484346 <HTML><HEAD></HEAD><BODY><P>Hello,&nbsp;&nbsp; I need some help with a statistical calculation and set analysis.&nbsp;&nbsp; I need to calculate the norm of a formula.&nbsp;&nbsp; </P><P></P><P>My formula is defined in a variable, I have also caculated the upper and lower bounds for my norm via variables.&nbsp;&nbsp;&nbsp; This is the formula I have:</P><P></P><P>=avg( {$&lt;BankID=, $(vMetric)={"&gt;$(vMinNorm)&lt;$(vMaxNorm)"}&gt;}&nbsp; $(vMetric) )</P><P></P><P>I think my problem is with having a calculated value (vMetric) to the left of the = in my set expression.&nbsp;&nbsp; Is there a way around this?&nbsp;&nbsp;&nbsp; Is there a better way of calculating the norm of a calculated value?&nbsp;&nbsp; </P><P></P><P>Any suggestions would be appreciated, I'm stumped by this.</P></BODY></HTML> Sat, 01 Jun 2013 18:51:38 GMT mjt_childrens 2013-06-01T18:51:38Z Norm calculation https://community.qlik.com/t5/QlikView/Norm-calculation/m-p/431063#M484346 <HTML><HEAD></HEAD><BODY><P>Hello,&nbsp;&nbsp; I need some help with a statistical calculation and set analysis.&nbsp;&nbsp; I need to calculate the norm of a formula.&nbsp;&nbsp; </P><P></P><P>My formula is defined in a variable, I have also caculated the upper and lower bounds for my norm via variables.&nbsp;&nbsp;&nbsp; This is the formula I have:</P><P></P><P>=avg( {$&lt;BankID=, $(vMetric)={"&gt;$(vMinNorm)&lt;$(vMaxNorm)"}&gt;}&nbsp; $(vMetric) )</P><P></P><P>I think my problem is with having a calculated value (vMetric) to the left of the = in my set expression.&nbsp;&nbsp; Is there a way around this?&nbsp;&nbsp;&nbsp; Is there a better way of calculating the norm of a calculated value?&nbsp;&nbsp; </P><P></P><P>Any suggestions would be appreciated, I'm stumped by this.</P></BODY></HTML> Sat, 01 Jun 2013 18:51:38 GMT https://community.qlik.com/t5/QlikView/Norm-calculation/m-p/431063#M484346 mjt_childrens 2013-06-01T18:51:38Z