How to derive a value in Straight table based on values in other column of Straight table

kailashkotak91 — Tue, 19 Mar 2019 22:03:33 GMT

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

Re: How to derive a value in Straight table based on values in other column of Straight table

kailashkotak91 — Wed, 20 Mar 2019 18:41:07 GMT

Hello experts,

Awaiting reply for the query.

Thanks,

Kailash Kotak

topic Re: How to derive a value in Straight table based on values in other column of Straight table in App Development

How to derive a value in Straight table based on values in other column of Straight table

Re: How to derive a value in Straight table based on values in other column of Straight table