topic Re: STDEV.S function in qlikview in QlikView

STDEV.S function in qlikview

Wed, 10 Jun 2015 06:41:56 GMT

Does someone know if QV has a function that similar to the STDEV.S function in excel? (the function calculates the sample standard deviation of a supplied set of values).

Thanks

Re: STDEV.S function in qlikview

swuehl — Wed, 10 Jun 2015 07:40:47 GMT

I believe the QV stdev() function works like STDEV.S in Excel.

For large sample sizes, both Excel functions (STDEV.S and STDEV.P) converge.

You can transform Stdev.S into Stdev.P by calculating something like

Stdev.S * sqrt(N-1) / sqrt(N) = Stdev.P

Stdev.S = sqrt(N) /sqrt(N-1) * Stdev.P

N being your sample size (count of values).

Re: STDEV.S function in qlikview

Wed, 10 Jun 2015 08:00:14 GMT

Hi thanks for answering.

lets say I have "store name" as dimension and I have 5 expressions: week1,week2,week3,week4 (each expression count the number of activities per store in different week number). The last expression is an average of all 4 weeks.

I want to calculate the "stdev()" of week1,week2,week3,week4 values. how can I do that?

hope I was clear enough, thank you

Re: STDEV.S function in qlikview

swuehl — Wed, 10 Jun 2015 08:24:27 GMT

If I understood correctly, basically replace avg() function with stdev().

If you need more help, please post a small sample or post the expression definitions.

Re: STDEV.S function in qlikview

Tue, 23 Jun 2015 12:30:46 GMT

sorry for the delay and thanks for answering.

If you can, please check the attached file. hope it was enough.

thank you

Re: STDEV.S function in qlikview

swuehl — Tue, 23 Jun 2015 22:31:50 GMT

Your sample file shows zeros for all expression.

But I think you can try using RangeStdev() function:

=RangeStdev(T1, T2, T3, T4)

Re: STDEV.S function in qlikview

Wed, 24 Jun 2015 07:17:14 GMT

Thank you so much! it worked!