How do you incorporate standard deviation within gauge object segments?

Wed, 15 Jul 2015 20:25:03 GMT

How would I use Standard deviation with the segments of the gauge object.

I will have 4 segments, low - moderate - elevated and high where elevated is 1 standard deviation above moderate and high is 2 standard deviations over moderate. I have created a few gauge charts with segments, but not sure how to handle standard deviation with it.

Thanks

Re: How do you incorporate standard deviation within gauge object segments?

rwunderlich — Wed, 15 Jul 2015 22:15:35 GMT

Assuming a field named "Value", you can compute the lower bound as:

median(Value) + stdev(Value) * 1

I suspect this is not exactly what you want, because the gauge would aggregate something like sum(Value) and therefore would always exceed the bound. Is this a gauge in a straight table and you want the median & stdev to be per row? If so, then use

median(aggr(sum(Value),dim1,dim2)) + stdev(aggr(sum(Value),dim1,dim2)) * 1

where dim1, dim2 are your chart dimensions.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

topic Re: How do you incorporate standard deviation within gauge object segments? in QlikView

How do you incorporate standard deviation within gauge object segments?

Re: How do you incorporate standard deviation within gauge object segments?