First and Second Derivate

[danigarciamejia]

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

[Dalton_Ruer · Accepted solution]

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. 

[danigarciamejia]

Works perfectly.

Thank you so much!