topic Re: Stdev using more than one variable?! in QlikView

Stdev using more than one variable?!

Thu, 28 Jun 2012 09:43:56 GMT

Hi,

If I want to use the Stdev function over more than one variable like this:

Stdev

(Total<Factory, [Package System], SizeCodeID, Variable, Year, Month>([web 1], [web 2], [web 3]))

How do I make it to work??

Thanks!

Brgs

Marita

Re: Stdev using more than one variable?!

Thu, 28 Jun 2012 10:35:05 GMT

Have you tried RangeStdev?

Re: Stdev using more than one variable?!

Thu, 28 Jun 2012 10:53:19 GMT

Thanks!

I´m sorry frankcrezee but how do you meen??

RangeStdev

([web 1],[web 2],[web 3]) dosen´t work......

Re: Stdev using more than one variable?!

Thu, 28 Jun 2012 11:01:09 GMT

Are you trying to calculate in the script or in the front end?

rangeStdev(var1,var2,var3) should work.

Could you maybe upload an qvw example file?

Re: Stdev using more than one variable?!

Thu, 28 Jun 2012 11:53:05 GMT

In an expression for a chart and when I enter the RangeStdev function i dont get any results!

Re: Stdev using more than one variable?!

Thu, 28 Jun 2012 12:02:59 GMT

Now i´ve uploaded the file, it´s the chart at the bottom, Stdev column!

Re: Stdev using more than one variable?!

swuehl — Thu, 28 Jun 2012 12:48:45 GMT

I believe rangestdev() expects a range of unambiguous values as arguments, no fields.

It's hard to advice you here, because its really easy to mess with statistics

It seems that your sample values are defined by

([web 1]+[middle web]+[last web])/3)

at least that's what you calculate the average from

Avg(Total<Factory, [Package System], SizeCodeID, Variable, Year, Month>([web 1]+[middle web]+[last web])/3)

I believe you don't need to use the total with fields in this case, since you are stating all your dimensions, so maybe

Avg( ([web 1]+[middle web]+[last web])/3)

is enough (it's reproducing the same results in your sample file).

So the standard deviation of your sample values should be

stdev( ([web 1]+[middle web]+[last web])/3 )

Hope this helps,

Stefan

Re: Stdev using more than one variable?!

Thu, 28 Jun 2012 13:06:04 GMT

Ok thank you Stefan for you reply. However this is the solution i hade from the beginning when i realized that the numbers i get were wrong. The reason for this is because I add all webs together and then do the Stdev function, this is not correct.

I need to bunch all webs together into one variable and then take Stdev on that variable or I need to take Stdev on several varaibles without adding them together first :-).

Hope this makes seans to someone, because i´m lost!?

Re: Stdev using more than one variable?!

swuehl — Thu, 28 Jun 2012 13:17:56 GMT

That's what I was talking about when I said, it's easy to mess around with statistics.

Well, before you try to calculate the stdev of different samples, what about creating one variable / sample from your three?

TotalSample:

LOAD ResultInformationID, [web 1] as TotalSample resident tbl_Result;

LOAD ResultInformationID, [middle web] as TotalSample resident tbl_Result;

LOAD ResultInformationID, [last web] as TotalSample resident tbl_Result;

And then just use

avg(TotalSample)

resp.

stdev(TotalSample)

This is assuming that your three samples can be combined into one.