topic Re: Standard Deviation on Line chart in QlikView

Standard Deviation on Line chart

tapassingh — Sat, 16 Nov 2024 20:52:29 GMT

I am building line chart which shows trend of users across a period (Week, 1 Month,3 Month, 6 Month, Year). I want to plot/highlight Standard deviation on that chart and mark lines with circles when it goes above or below the deviation. Like nelsons rule.

Re: Standard Deviation on Line chart

chrismarlow — Tue, 14 May 2019 19:03:21 GMT

Hi,

You can use Total with Avg and StDev to lines for the bounds & then use a formula to return nulls when you are not below/above to get something like the below;

I've attached QVW, but I am on personal edition so you may not be able to open.

Cheers,

Chris.

Re: Standard Deviation on Line chart

tapassingh — Thu, 16 May 2019 05:08:09 GMT

Thanks Chris, this helped a lot.