topic Re: KPI Text Top 1 in Featured Members

KPI Text Top 1

Jacobo — Thu, 22 Dec 2022 20:58:44 GMT

Hello team, I´m new in Qlik sense and I was wondering how to get the comment with the most votes from a table, that is, the top 1, if I choose KPI it only sends me numbers, but I want it to say the comment number 1

Re: KPI Text Top 1

maxgro — Thu, 22 Dec 2022 21:20:10 GMT

T:
load * Inline [
Comment, Vote
aaaa,1
bbbb,1
cccc,1
aaaa,1
aaaa,1
bbbb,1
bbbb,1
aaaa,1
];

you can use this expression in the KPI

Only({<Comment = {"=Rank(Sum(Vote),4)<=1"}>} Comment)

or this

FirstSortedValue(Comment, -Aggr(Sum(Vote), Comment))

Re: KPI Text Top 1

Jacobo — Thu, 22 Dec 2022 23:16:46 GMT

Thanks the info comes like this...

Re: KPI Text Top 1

maxgro — Tue, 27 Dec 2022 10:24:32 GMT

with your data

T2:
load * inline [
PARA DEJAR PIRELLI?
Jubilacion
Jubilacion
Jubilacion
Conflicto con mi supervisor actual
Otro
Mejor....
Conflicto interpersonal / ...
];

try this expression

Only({<[PARA DEJAR PIRELLI?] = {"=Rank(Count([PARA DEJAR PIRELLI?]),4)<=1"}>} [PARA DEJAR PIRELLI?])