Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
AdamPi
Contributor
Contributor

Shift Line Chart Guardrails to Std Dev from the Average

I am attempting to create the below, which I can do with a Std Dev number calculated and hard coded.  I am looking to have it variable, so when filters change this will update.

If I run the below it generates the StDev of 478

Stdev(AGGR(SUM(UNIT_COUNT * [OMS_Units.Line Quantity]),[Created.Fiscal Week]))

If I run the below I don't get any line data:  

RANGEAVG(ABOVE(SUM(UNT_COUNT * [OMS_Units.Line Quantity]),0,13))+Stdev(AGGR(SUM(UNIT_COUNT * [OMS_Units.Line Quantity]),[Created.Fiscal Week]))

Lastly I hard coded below to generate chart, but I need to above to keep chart dynamic with different filters:

RANGEAVG(ABOVE(SUM(UNT_COUNT * [OMS_Units.Line Quantity]),0,13))+487

db2bfa35f1864945a87cef6c0335f253.png

0 Replies