topic how to use Lanier regression algorithm in qlik view in QlikView

how to use Lanier regression algorithm in qlik view

Fri, 21 Oct 2011 17:31:54 GMT

hi all,

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

Lanier regression algorithm in qlik view

Thanks Savi.

Fri, 21 Oct 2011 17:44:39 GMT

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.

Fri, 21 Oct 2011 18:34:42 GMT

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

Fri, 21 Oct 2011 18:36:49 GMT

This is what I have done:

Set sort order to Numeric Ascending.

Kiran

Fri, 21 Oct 2011 18:43:23 GMT

Thanks Kiran I’ll try it.

Savi.

Fri, 21 Oct 2011 19:08:52 GMT

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

Sat, 22 Oct 2011 01:15:51 GMT

Equation can be found using:

Kiran.