# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Contributor

## Chart Aggr - Max of Dimension

Hi all,

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.

=max(aggr(count([AssignedToTeam]), [AssignedToTeam]))

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.

Many thanks.

1 Solution

Accepted Solutions
Valued Contributor II

## Re: Chart Aggr - Max of Dimension

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!

4 Replies
Valued Contributor III

## Re: Chart Aggr - Max of Dimension

Could you upload a sample qvw?

Not applicable

## Re: Chart Aggr - Max of Dimension

when you use aggregation it will give the maximum value for that particular AssignedToTeam.

you cant get the same value for all

Valued Contributor II

## Re: Chart Aggr - Max of Dimension

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!

Contributor