Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
tapassingh
New Contributor

Standard Deviation on Line chart

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.

Tags (1)
Labels (1)
2 Replies
Highlighted
chrismarlow
Valued Contributor

Re: Standard Deviation on Line chart

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;

20190514_1.png

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

Cheers,

Chris.

Highlighted
tapassingh
New Contributor

Re: Standard Deviation on Line chart

Thanks Chris, this helped a lot.