topic Display all the results possible if equals in App Development

Display all the results possible if equals

smic — Mon, 17 Aug 2020 11:34:57 GMT

Hi,

I use a form allowing me to display the name of a person according to his results:
=FirstSortedValue(DISTINCT Name,-aggr(sum(test_ID), player_ID))

I only display in my KPI the "max" thanks to the firstshortedvalue formula.

However, I would like this time to display all the people in case of identical result ... How to do please ??

If there are several possible results, display them all by separating them with "commas" for example

Thanks you !

Regards

Re: Display all the results possible if equals

haskia — Mon, 17 Aug 2020 13:54:31 GMT

Hi Smic.

Have a look at the CONCAT()-formula. You can use the DISTINCT -parameter and even a custom sorting like yours above.

Re: Display all the results possible if equals

Usama — Mon, 17 Aug 2020 16:06:05 GMT

Hi Smic,
Can you please attach qvf or screenshot?

Thanks

Re: Display all the results possible if equals

smic — Wed, 19 Aug 2020 22:00:27 GMT

Hi,

thanks you to reply.
So, i have 2 table like this:

Player_ID	Player_Name	Test_ID	Player_ID
1	Toto	1	1
2	Titi	1	2
3	Tata	1	3
		2	1
		2	2

I want to know my players who are most present during the tests. I want to display the most present player during the tests. However, as in the current case, several players are tied ... I therefore wish that in my KPI indicator, there is the list of the first names of the most present players. Currently with the fistsortedvalue only one is displayed even if there is a tie ...

the formula with the sum is wrong. It is a count that it takes:

= FirstSortedValue (DISTINCT Name, -aggr (sum (test_ID), player_ID))

PS: I just saw that in the custom objects, there were multi KPIs. But now i want to filter the set analysis with a "count" function ...

=count({<player_ID =- {'0','-1'}, count(distinct test_id) = max(aggr(count({<Distinct test_id), player_ID))>} distinct test_id)

Regards

Re: Display all the results possible if equals

Kushal_Chawda — Wed, 19 Aug 2020 22:02:19 GMT

What is the expected output? Can you share some sample data?

Re: Display all the results possible if equals

smic — Wed, 19 Aug 2020 22:45:54 GMT

hi,

I want this (because these two persons have been present during 2 tests sessions):

Toto	Titi
2	2

In a Multi KPI chart.

In fact, i want to count distinct test_id by player_id.
But i want display only Player_id where count distinct test_id = max(aggr(count( Distinct test_id), Player_id))
How to filter the count function and keep only max values of this count please ??

Regards

Re: Display all the results possible if equals

Kushal_Chawda — Wed, 19 Aug 2020 23:11:01 GMT

// Replace below inline table with your actual data Data: Load * Inline [ Player_id,Player_Name, Test_id 1,toto,1 2,titi,1 1,toto,2 2,titi,2 3,tata,1 ]; Now you can use below expression in KPI object =concat(aggr(if(max(total aggr(Count(distinct Test_id),Player_id))=max(total <Player_id>aggr(Count(distinct Test_id),Player_id)), Player_Name&':'&count(distinct Test_id)),Player_id),',')

Re: Display all the results possible if equals

smic — Fri, 21 Aug 2020 09:34:21 GMT

Hi Kush,

thanks you for helping !!