1 Reply Latest reply: Mar 10, 2016 11:17 AM by Gysbert Wassenaar RSS

    Nested Count-If function

    Matt Lozier

      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?

       

       

      IDPrice
      a$10
      b$21
      c$45
      d$84
      e$7
      f$48
      g$58
      h$61
      i$23