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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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