Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

evgeniystuchalk
Contributor II

Base lines in chart, based on standart deviation

Hi! I want add to my linear chart , that represents sales sum by day, following base lines:

average per day, average per day + 3 standart deviation (upper baseline), average per day - 3 standart deviation (lower baseline).


Here is my result:


4c397d7067.jpg

As you can see, upper and lower baselines is -6.93k and 78.83k. All values is in range. But i'm espect to see something like this:

trend03.png

My measure: sum({$<Eantity={"Sales"}, DateType={"Sales_Дата"}, Mode={"STD"}>} [Sales.Sum])

Avg Baseline: avg(aggr(sum({$<Eantity={"Sales"}, DateType={"Sales_Дата"}, Mode={"STD"}>} [Sales.Sum]), Day)

Stdev Formula: stdev(aggr(sum({$<Eantity={"Sales"}, DateType={"Sales_Дата"}, Mode={"STD"}>} [Sales.Sum]), Day)

Day - dimension in main calendar table. Not all Days have Sales.Sum value.


DateType - field in main calendar, that makes aggregation om concret date type, like:"DealCreate" or "DealClose". remoning that condition from set analysis don't change anything.

Why lower baseline below zero, if there is no negative value in Sales.Sum? May be I need calculate it in another way?

Result, that i want - Excellent Analytics Tip #9: Leverage Statistical Control Limits - Occam's Razor by Avinash Kaushik