I 'm new to Qlik, and am trying to figure out a relatively complex countif statement. I'm looking at a list of prices that pertain to unique ID's, and trying to get a count of the prices that fall between the mean +1 standard deviation and the mean - 1 standard deviation. In Excel, I would do it like this:
=count(price) - countif(price<(average(price)-stdev(price)) - countif(price>(average(price)+stdev(price))
Basically, take the total count - anything that falls outside my range. Thoughts?