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: 
prees959
Creator II
Creator II

Bar Chart - Grouping Dimension

Hi,

I have a simple bar chart that counts the number of sales by a sales rep.

Would it be possible to display the number of users with a certain amount of sales rather than an individual user?

er; if the graph shows :

User A 25 Sales

User B 25 Sales

User C 40 Sales

User D 40 Sales

User E 40 Sales

User F 2 Sales

User G 10 Sales

could it effectively show:


40 Sales - 3 Users

25 Sales - 2 Users

40 Sales - 3 Users

10 Sales - 1 User

2 Sales - 1 User

Many thanks,

Phil

1 Solution

Accepted Solutions
sunny_talwar

May be this

Dimension

Aggr(Sum(Sales), [Sales Rep])

Expression

Count(DISTINCT [Sales Rep])

View solution in original post

6 Replies
sunny_talwar

May be this

Dimension

Aggr(Sum(Sales), [Sales Rep])

Expression

Count(DISTINCT [Sales Rep])

prees959
Creator II
Creator II
Author

Perfect Thank you!

vishsaggi
Champion III
Champion III

Hello Phil,

Can you close the thread Marking Sunny's response correct/helpful. That way other members can benefit from your query.

Thanks,
V.

prees959
Creator II
Creator II
Author

Hi I hope you don't mind me asking another question on the back of this one?

I would like to show the average number of sales a rep would make?

Thanks,

Phil,

sunny_talwar

May be this

Dimension

Aggr(Avg(Sales), [Sales Rep])

Expression

Count(DISTINCT [Sales Rep])

prees959
Creator II
Creator II
Author

thanks !!