Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

pgriffiths
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;

Qlikview Chart Aggr.png

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
jerem1234
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))

Ex1.PNG.png

Hope this helps!

4 Replies
senpradip007
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

jerem1234
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))

Ex1.PNG.png

Hope this helps!

pgriffiths
Contributor

Re: Chart Aggr - Max of Dimension

Thanks Jeremiah, your a star.

I thought I was close.

Thanks to everyone else for their help also.

Community Browser