Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
Im beginner of qlik view. I want to know how to use
Lanier regression algorithm in qlik view
Thanks Savi.
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.
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
This is what I have done:
Set sort order to Numeric Ascending.
Kiran
Thanks Kiran I’ll try it.
Savi.
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
Equation can be found using:
Kiran.