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

Announcements
Join us in Toronto Sept 9th 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