Hello Qlik Experts,
In the attached, i am looking to find the badge owner based on the number of times the badge appeared. For example, the 1st badge appeared 65 times however each 65 of the 65 badges can have different owner, can have a single owner or there can be a split of 30 badge to one owner, 20 to another and the rest 15 to another owner. I am looking to solve based on the number of times the same owner appeared. For instance in the case where the 1st badge appeared 65 times and the owners are split like 30 badge to one owner, 20 to another and the rest 15. I want to put in the name of the owner whose badge appeared 30 times (max times) . Can you please help with this ? I have the following expression to count the badges.
if(count(distinct(Row))=1,
if(len(Name)>=1,Count(Badge),'Not a Server'))
Thanks in advance.
Regards,
Kailash Kotak
