11 Replies Latest reply: Nov 3, 2016 2:46 PM by Sunny Talwar RSS

    both inner and outer set analysis with Aggr

    Samuel Lin

      Hello Qlikers!!

       

      I have the following expression, but the result isn't correct....

       

      Count({<Revenue={'>1000'}>} Aggr(sum({<dimension1={'AAA', 'BBB'}, dimension2={'XXX'}>} Revenue), EmailAddress))

       

      basically first I want Aggr(sum({<dimension1={'AAA', 'BBB'}, dimension2={'XXX'}>} Revenue), EmailAddress)

       

      so the sum of revenue by EmailAddress, and then, I would like to count the number of emailAddresses that has revenue greater than say 1000

       

      Should be straight forward?

       

      Thank you for your help!