Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
Hi Shobana, I think you only need this:
sum(Sales)/sum(TOTAL <Team> Sales)
Thanks a lot Ruben, that worked!!!