Discussion Board for collaboration on QlikView Layout & Visualizations.
I'm having loads of fun with charts, but have come across the below and wonder if anyone can help.
I have a chart as follows;
The Blue bar is calculated by an expression =count(AssignedToTeam)
I want the red to show the Max of count(AssignedToTeam) in the chart.
After reading my qlikview developer book and looking online I have come up with the following expression and can't figure out why it isn't working as I expect.
I want all of the Red bars to be the Max Value. In this example 13565.
This is probably an easy one, but I can't see why this isn't giving me what I want.
Go to Solution.
What is your dimension? If your dimension is also AssignedToTeam, then try this (you need to add the total qualifier):
=max(total aggr(count([AssignedToTeam]), [AssignedToTeam]))
or if its not your dimension, use:
=max(total aggr(count([AssignedToTeam]), YOURDIMENSION))
Hope this helps!
Could you upload a sample qvw?
when you use aggregation it will give the maximum value for that particular AssignedToTeam.
you cant get the same value for all
Thanks Jeremiah, your a star.
I thought I was close.
Thanks to everyone else for their help also.