Calculate and group the counts

[pgloc2020]

Hello all,

I have a data displaying applications and the applicants who submitted those applications.

I have to group the values and display the counts of applicants who submitted 1 applications, 2 applications, 3 applications and so on.

It's very easy to make a pivot table in excel but I want to replicate same in Qlik sense. I just could not figure it out how to group both the applicants and number of applications?

Below is the pivot table created in Excel sheet-

Data is something like this-

Column Application contains different types of applications such as Testing, Registration, Exam etc

Column Applicant ID listed the IDs of the applicant who submitted those applications. 

Please help.

Thank you all!

[chaorenzhu · Accepted solution]

You can create a pivot table, use aggr(count(ApplicantID),ApplicantID) as dimension and count(aggr(count(ApplicantID),ApplicantID)) as measure

[pgloc2020]

OMG...It works. Thank you so much. You are awesome.