Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Works perfectly.
Thank you so much!