I have a view that lists users. These users have skills. Two users are listed multiple times; one user three times; twice with "no skill" and once with the skill they have; another one twice, once with "no skill" and once with the skill they have. If I enable aggregation, skills are gone; if I don't, I get duplicate results. I have tried distinct as well, to no avail. Please see the screenshot below.

enter image description here

What can I do to eliminate this issue?


  • Just put in a normal filter to filter on skills, and set it to 'Is not equal to' with Value 'No Skill', or something like that, depending on what type of field your skills are. Dec 23 '14 at 4:25
  • @J.Reynolds As you can see in the screenshot above, some users who aren't listed twice not having a skill is indeed valid.
    – Kartagis
    Dec 23 '14 at 5:51
  • @J.Reynolds would an export of the view help? paste.debian.net/137807
    – Kartagis
    Dec 23 '14 at 7:32
  • Aggregation with "group results" for the name should group all field for that user together. Dec 25 '14 at 15:35
  • @Neograph734 when I aggregate, group results is default and skills are shown multiple times. Please see dl.dropboxusercontent.com/u/11918318/…
    – Kartagis
    Dec 26 '14 at 7:14

If the skills come from taxonomy terms, you can do as follows.

Choose 'group results' for both title and the taxonomy terms. Then in the taxonomy terms dialog it should show a dropdown to group by 'entity id' or 'taxonomy id'. Choose 'entity id'.

No need to check the boxes.


(cant embed the image on phone...)

  • Worked for me, thanks! I was about to pull out my hair.
    – Christia
    Jun 13 '17 at 0:03

It seems that some profiles were not showing because their "skills" were missing. When I completed a profile in a way that they have a "skill", it also showed up.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.