topic Re: First and Second Derivate in App Development

First and Second Derivate

danigarciamejia — Sat, 16 Nov 2024 17:18:00 GMT

Hello

I need to make the First Derivative and Second Derivative of a function on a line graph.

Is it possible in Qlik Sense? Is there any function to calculate? Can anyone share examples?

Thank you so much.

Regards,
Daniel

Re: First and Second Derivate

Dalton_Ruer — Mon, 12 Apr 2021 14:45:49 GMT

There is a Standard Deviation (STDEV) function in Qlik Sense just click here for the help page for it.

You can simply use 2* to get the second. The help page for it will also show you the Average (AVG) function. Then you can combine them as the expressions for reference lines.

Adding these for a control chart so that end users can easily see what is just noise in the variance over time vs what is statistically significant is very common.

Re: First and Second Derivate

danigarciamejia — Tue, 20 Apr 2021 08:29:40 GMT

Works perfectly.

Thank you so much!