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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Lena4
Contributor III
Contributor III

Summing Polynomials?

I'm having difficulty summing this polynomial, I want to get a total of indvidual row results.  Any suggestions on how to go about this? Wrapping it in sum() or rangesum() is not working. 

 


10.384*pow([Normalized Month],5) - 33*pow([Normalized Month],4) + 38.831*pow([Normalized Month],3) - 20.218*pow([Normalized Month],2) + 4.1059*[Normalized Month] - 0.1037

 

*the Normalized Month dimension is a decimal

Labels (3)
1 Reply
rubenmarin

Hi, how should be total calculated when there are different rows with different [NormalizedMonth] values? In example, to sum all the rows, it could be: Sum(Aggr([YourExpression], [TableDimension(s)]))