Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yelin_nyu
Creator
Creator

class(), increment by standard deviation

want to show a chart with count of error on y, and standard deviation group of error on x

error is a field already in table, need to calculate standard deviation group on front end. I know i can do it in the back end, but i what to keep standard dev dynamic based on selected criteria.

outcome of the chart in table format:

say standard devation is 2, and mean is 20

stdev group   error range

-1                   18<=x<20         

0                    20

1                    20<x<=22

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Your buckets are not of equal size, which is not supported by the class function.

You can create two variables vSTD and vAVG:

=stdev(error)

=avg(error)

and then a chart with a calculated dimension

=class(error, vSTD, 'error', vAVG)

and an expression

=count(x)

to show a histogram with buckets of size of the standard deviation grouped around the mean value.

View solution in original post

1 Reply
swuehl
MVP
MVP

Your buckets are not of equal size, which is not supported by the class function.

You can create two variables vSTD and vAVG:

=stdev(error)

=avg(error)

and then a chart with a calculated dimension

=class(error, vSTD, 'error', vAVG)

and an expression

=count(x)

to show a histogram with buckets of size of the standard deviation grouped around the mean value.