Equivalent Excel Stdevp in Qlikview

[Anonymous]

Hi

Is there any equivalent function like excel Stdevp?

I found some solutions in this forum like:

=sqrt(sum(aggr(pow(sum(Field)
-
sum(total Field)/count(total distinct Date),2),Date))/Count(TOTAL DISTINCT Date))

but it does not work accurately

Thanks a lot

[swuehl · Accepted solution]

Have a look at my answer here

Re: STDEV.S function in qlikview

[Anonymous]

Yes. Thank you. Works good.