Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mjt_childrens
Contributor III
Contributor III
‎2013-06-01 02:51 PM

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.

430 Views
0 Likes
0 Replies