2 Replies Latest reply: Jun 2, 2015 12:15 PM by Shobana Sridaran RSS

    Aggr() Question

    Shobana Sridaran



      I'm fairly new to qlikview and struggling to implement the following chart.


      I started using aggr() function hoping that would be helpful, but it doesn't give the results that I need.


      This is what I'm trying to implement:


      When I use =aggr(sum(Sales)/sum(TOTAL Sales),Team, TeamMember), I get this:



      Any advice would be appreciated. Thanks in advance.