Top 5 Names

[paulwalker]

Hi Community,

I have 3 fields Name, Status and empcount.

each name has multiple status. (If I take top 5 names working fine as expected)If I combine Name and Status (Name&'-'&Status), I want it the same result with composite key

Out Put Should be below (if we have multiple status we can pick anyone of them, but Name should be the same for both)

@tresesco, @MayilVahanan,  @Kushal_Chawda, @marcus_sommer, @stevedark 

and experts can you please take a look!

Thanks in Advance!

[paulwalker]

if anybody help much appreciated !

[qlikeers]

Hi! I don't understand a bit, where is the problem?

Or I'm misunderstanding the task.

Can't you just make a table? Where:

Dimension: =Name&'-'&MaxString(Status)

Measure: Your count. -> COUNT(XXX)

*Maxstring is there to bind one of many statuses, as you wrote.

[BrunPierre]

Hi, @paulwalker  as calculated dimension.

=Aggr(MaxString(Name&'-'&Status), Name)