Forecasting - polynomial equation

[#1]

I am trying to implement Excel formulas logic in Qlikview to derive polynomial component as per Excel sample file attached.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3731.Polynomial-equation-_2D00_-sample.xlsx:550:0]

M1-M6 components are calculated using array LINEST formulas.

In QV test file I have created dimensions X^6...X^1 which I want to pass to linest_B. Is it achievable?

[Anonymous]

Hi Nikita,

Would you able to get the solution for this?

Thanks,

Pramod