Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make an frequency distribution.

Hi. I´m new using Qlikview and I have a few questions.

I have a list of names where several of these occur more than once. I want to be able to count the number of occurences of a name and make a bar chart with number of people on the y axis and number of times they occur on the x axis.

How do I do this? Any suggestions?

With kind regards!

/Hans

3 Replies
Not applicable
Author

example: 

Dimension:   Name

Expression: Count(Name)

Not applicable
Author

Using name as an dimension will just give how many times name occur. What I want to be able to show is how many people occur 1 time, 2 times, 3 times and so fourth.

So on the y axis number of people and on the x axis 1, 2, 3,.....


Not applicable
Author

Found the solution.

Using

Dimension: Aggr(Count(Name), Name)

Expression: Count(distinct(Name))

/Hans