how to use Lanier regression algorithm in qlik view

[#1]

hi all,

Im beginner of qlik view. I want to know how to use

Lanier regression  algorithm in qlik view

Thanks Savi.

[#2]

Hi Savi,

Did you mean Linear Regression?.

If you want for forcast by Linear Regression:

Go to Expression tab for the expression you want to forecast. (only works for your line chart)

Select Linear in Trend Lines.

Go to Axis tab, select the expression and include the no.of time buckets you want to forecast.

You shall find them in the attachement.

Custom regression using LR terms can be found in LINEST_* functions. Refer help manual

Hope this helps,

Kiran.

[#3]

Thanks Kirsn.

I can’t open yourfile. Because I used QV personal edition. Can u send me a link or some documents related this area if don’t mind.

Thanks

Savi

[#4]

This is what I have done:

Set sort order to Numeric Ascending.

Kiran

[#5]

Thanks Kiran I’ll try it.

Savi.

[#6]

Hi Kiran,

This is the predicted area (Blue color).Is there any method to see mathematical equation and data points of the predicted area?

Thanks,

Savi

[#7]

Equation can be found using:

Kiran.