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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
ekinney
Contributor
Contributor

Implementing a range of -4 Standard Deviations to +4 Standard Deviations on an X Axis chart

Im developing some visuals that have to do with a normal distribution. I have the mean, and standard deviation numbers down, and I managed to get some form of bell curve plotted on a combo chart

ekinney_0-1790885456108.png

Problem is, I want the bell curve to be centered, and the range of the X axis to show -4 to +4 standard deviations away from the mean. If anyone has any insight as to how to go about that, it would be lovely. As far as it seems though I don't think it would be possible as the X axis is automatically generated on the dimension used, and my dimension is tied to the measure.

 

Dimension expression: Round([MEASURE], 0.1)

 

Measure Expression: Only(NormDist(Round([MEASURE], 0.1), Avg(TOTAL [MEASURE]), StDev( [MEASURE])*0.1*Count(TOTAL [MEASURE])

 

Any help is appreciated, thanks!

Labels (5)
0 Replies