Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
qlikview979
Valued Contributor

All Top 3 Sales People Names in Text object

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

 

 

 

 

 

1 Solution

Accepted Solutions
spsrk_84
Contributor III

Re: All Top 3 Sales People Names in Text object

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

1 Reply
spsrk_84
Contributor III

Re: All Top 3 Sales People Names in Text object

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