I need to use both the standard deviation and the median function.
My data has Numerators and Denominators. Below is what an example table might look like.
The problem is that all the numerators for a single name (Myname) need to be summed.
All the Denominators for a single name (MyName) need to be summed. This sum must be performed before I can do the division i.e. Numerator Over Denominator. I can get the standard deviation by creating a chart and using the StdDev total as the column summary, but I need to do this in a text box. Additionally the Median function is not available in the Chart column total.
Let's forget the median issue and just focus on Standard deviation.
If you look at my example, you will see that the stddev which is generated via Qlik in the chart, is the correct standard deviation.
The point is, I need this number in a text box. I could pull the number off the Chars via a Macro, but I don't want to use a Macro because they don't work in a webb base. Therefore I want to use a calculation in a text box. I thought the formula/calculation I stated in the original post would work, but it yields a different number than that of the the Qlik Chart generated StdDev.
Additionally, If you attempt the same formula as I am using in the text box with Median instead of StdDev, you will also find that the numbers do not match.
Essentially, the text box formula does not work, and I don't know why.
Does any one have a different formula I can use which would yield the correct number ?