topic All Top 3 Sales People Names in Text object in QlikView

All Top 3 Sales People Names in Text object

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: All Top 3 Sales People Names in Text object

spsrk_84 — Thu, 02 May 2019 16:52:26 GMT

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))