Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
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.

0 Replies