topic Re: Trendline section in Qlik Sense in App Development

Trendline section in Qlik Sense

ClementByr — Sat, 16 Nov 2024 20:37:27 GMT

Hello,

I am developping a Qlik Sense App and I need to to do a Nth degree polynomial trendline.

During my research, I have found that QlikView have a Trendline section that does not seems to exist in Qlik Sense. There is also this topic about making formula to calculate trend line in Qlik Sense that was created in 2017 :

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Calculating-trend-lines-values-and-formulas-on-charts-and-tables/ta-p/1479463

I am wondering by the time of this topic if a solution have been found.

Does anyone know if there is actually an easy way to calculate a trend line like QlikView, or if Qlik intend to add this functionnality in the near future, please ?

Also, if someone know the formula to calculate Nth degree polynomial trendline that would be much apreciated, thanks.

Best Regards.

Re: Trendline section in Qlik Sense

JordyWegman — Thu, 20 Jun 2019 10:38:36 GMT

Hi Clement,

Qlik doesn't offer this and probably won't offer this because it's a statistics part.. less a BI part. You can use the Vizlib Line Chart, it contains a polynomial function for a trendline. But you can't edit this formula.

Jordy

Climber

Re: Trendline section in Qlik Sense

ClementByr — Fri, 21 Jun 2019 07:32:27 GMT

Hi Jordy,

Thank you for the quick reply.

QlikView is also a BI tools and has the functionnality to create trend line, I think it is still possible that Qlik implements a section for trend lines in Qlik Sense.

In any case, thanks for proposing the extension Vizlib but I would not be able to use it because my companie does not use extension in their apps. I will try to figure out a formula using the python back-end.

Clément

Re: Trendline section in Qlik Sense

Frank_Hartmann — Fri, 21 Jun 2019 08:11:35 GMT

See attached qvf for "Polynomial Trendline 2nd degree"

hope this helps

Re: Trendline section in Qlik Sense

H_Julian — Sun, 23 Jun 2019 10:54:43 GMT

We were facing the same problem within our Company a few Months ago.

I was able to calculate a moving Average Trendline within the Script Editor, but to properly create polynomial functions within Qlik you should use a Python API and do the necessary Regressions there

Best Regards

Julian