Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pgriffiths
Creator
Creator

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
Specialist II
Specialist II

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!

View solution in original post

4 Replies
senpradip007
Specialist III
Specialist III

Could you upload a sample qvw?

Not applicable

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

you cant get the same value for all

jerem1234
Specialist II
Specialist II

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
Creator
Creator
Author

Thanks Jeremiah, your a star.

I thought I was close.

Thanks to everyone else for their help also.