All Top 3 Sales People Names in Text object

[qlikview979]

Hi all,

I have below requirement  and  sample data like

Load * inline [

Name,sales

A,100

B,100

C,100

D,200

E,200

F,300

];

but i need show output  in  three different TEXT OBJECT like below

A,B,C          D,E           F

100             200           300

Regards

Mahesh

[spsrk_84 · Accepted solution]

Hi Mahesh,

Please try below.

Concat(DISTINCT Aggr(
If(
(Count( DISTINCT {<NPS_Date={"$(vNPSMaxdate)"},NPS_SLA={'Met'},NPS_SLA-={'Not Met'}>}[Request ID])/Count(DISTINCT [Request ID]))
=
Max(TOTAL Aggr(Count( DISTINCT {<NPS_Date={"$(vNPSMaxdate)"},NPS_SLA={'Met'},NPS_SLA-={'Not Met'}>}[Request ID])/Count(DISTINCT [Request ID]), NPS_owner)), NPS_owner), NPS_owner), chr(13))