2 Replies Latest reply: Oct 28, 2016 10:55 AM by Kaitlin Almirall RSS

    Help with nested aggregation

    Kaitlin Almirall

      Hello!  I'm trying to figure out how to modify this expression so that qliksense accepts the formula (as nested aggregation is not allowed).  Basically, if an average of scores is greater than or equal to 3, I want that to generate a count of "1", and then be able to sum those 1s (so that this will translate to a pivot format).  Here's my formula:

       

      Sum(IF(Avg({$<[ELPScores.Concept]={'1.1*','1.2*','2.1*','2.2*','2.4*','3.1*','4.2*'}>} IndicatorScores)>=3.0,1))

       

       

      Thanks for the help!

      Katie