topic stdev of a count in QlikView

SOLVED - stdev of a count

Fri, 25 Mar 2011 22:43:10 GMT

Good evening,

I have a table which are recorded the numbers of requests, I created a line graph counting the records.

Putting the average was easy, but I am not aware calculate the standard deviation, the day had more and less records.

Any tips?

Hugs

Gledson

stdev of a count

Sat, 26 Mar 2011 08:06:00 GMT

I suspect you want to display a confident interval ?

You can add lines in your charts as new expressions :

To calculate the standard deviation , try this =Stdev( ALL aggr( COUNT( NumOco) , DataOco) )

In your chart, add new expression :

=AVG ( ALL aggr( COUNT( NumOco) , DataOco) ) + 1.96 * Stdev( ALL aggr( COUNT( NumOco) , DataOco) )

for the upper CL

stdev of a count

Sat, 26 Mar 2011 12:16:22 GMT

Thanks Jean-Jacques Jesua !

Works fine, thans a lot!!!

Hugs

Gledson