Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
danigarciamejia
Luminary Alumni
Luminary Alumni

First and Second Derivate

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

Labels (3)
1 Solution

Accepted Solutions
Dalton_Ruer
Employee
Employee

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. 

View solution in original post

2 Replies
Dalton_Ruer
Employee
Employee

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
Luminary Alumni
Luminary Alumni
Author

Works perfectly.

Thank you so much!