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

    Aggr() Question

    Shobana Sridaran

      Hi,

       

      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:

      Req.png

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

       

      Qlik.png

      Any advice would be appreciated. Thanks in advance.