set analysis expression

[Praten361998]

How to get the count of numbers as per assignee name 

i want result like this 

avinash shukla  28

Divya Thareja 19

like that i want it for 20 assignee

[MartW]

@Praten361998  the screenshot you show, is this the entire table?

because normally qlik will look at data in the frontend and see if it can be combined. (see below)

so in the datamodel you have a table that looks like this.

ID	Name
1	a
2	a
3	b

then Qlik would show this in the front end (as you display this data as a table)

Name	count(ID)
a	2
b	1

if you have extra columns in your table it is possible that those columns all got different values in them. therefor Qlik doens't combine the data

[Praten361998]

thank you all for help