Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

mjt_childrens
New Contributor III

Norm calculation

Hello,   I need some help with a statistical calculation and set analysis.   I need to calculate the norm of a formula.  

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:

=avg( {$<BankID=, $(vMetric)={">$(vMinNorm)<$(vMaxNorm)"}>}  $(vMetric) )

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?  

Any suggestions would be appreciated, I'm stumped by this.

Tags (2)
Community Browser