topic Norm calculation in QlikView Creating Analytics
https://community.qlik.com/t5/QlikView-Creating-Analytics/Norm-calculation/m-p/431063#M17937
<HTML><HEAD></HEAD><BODY><P>Hello, I need some help with a statistical calculation and set analysis. I need to calculate the norm of a formula. </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. This is the formula I have:</P><P></P><P>=avg( {$<BankID=, $(vMetric)={">$(vMinNorm)<$(vMaxNorm)"}>} $(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. Is there a way around this? Is there a better way of calculating the norm of a calculated value? </P><P></P><P>Any suggestions would be appreciated, I'm stumped by this.</P></BODY></HTML>Sat, 01 Jun 2013 18:51:38 GMTmjt_childrens2013-06-01T18:51:38ZNorm calculation
https://community.qlik.com/t5/QlikView-Creating-Analytics/Norm-calculation/m-p/431063#M17937
<HTML><HEAD></HEAD><BODY><P>Hello, I need some help with a statistical calculation and set analysis. I need to calculate the norm of a formula. </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. This is the formula I have:</P><P></P><P>=avg( {$<BankID=, $(vMetric)={">$(vMinNorm)<$(vMaxNorm)"}>} $(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. Is there a way around this? Is there a better way of calculating the norm of a calculated value? </P><P></P><P>Any suggestions would be appreciated, I'm stumped by this.</P></BODY></HTML>Sat, 01 Jun 2013 18:51:38 GMThttps://community.qlik.com/t5/QlikView-Creating-Analytics/Norm-calculation/m-p/431063#M17937mjt_childrens2013-06-01T18:51:38Z