Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
example:
Dimension: Name
Expression: Count(Name)
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,.....
Found the solution.
Using
Dimension: Aggr(Count(Name), Name)
Expression: Count(distinct(Name))
/Hans