topic Re: top 3 salesmen in textbox in QlikView

top 3 salesmen in textbox

Tue, 11 Nov 2014 05:13:02 GMT

hello everyone,

suppose there is a table having the sales done by salesmen and names of the salesmen.if i have to show the list of top 3 salesmen based on sales done in a text box,how can i show this?

thanking you,

kunal bhattacharjee

Re: top 3 salesmen in textbox

anbu1984 — Tue, 11 Nov 2014 05:19:19 GMT

Check this app

Re: top 3 salesmen in textbox

amit_saini — Tue, 11 Nov 2014 05:23:00 GMT

Kunal ,

Try this as expression:

=aggr(if(Rank(sum(Sales))<=3,Sales),Sales) (For calculating Top 3)

Thanks,
AS

Re: top 3 salesmen in textbox

SergeyMak — Tue, 11 Nov 2014 05:24:55 GMT

Hi,

Why do you need to see them in textbox? Why can't you use a straight table and use format to get rid of all the lines?

With textbox you can try to look at Rank() and Concat() functions

Regards,

Sergey

Re: top 3 salesmen in textbox

amit_saini — Tue, 11 Nov 2014 05:26:30 GMT

For top 3 salesmasn:

=aggr(if(Rank(sum(Sales))<=3,Salesman),Salesman)

Thanks,
AS

Re: top 3 salesmen in textbox

jagan — Tue, 11 Nov 2014 05:35:19 GMT

Hi Kunal,

Check this expression

=Concat(If(Aggr(Rank(Sales), Salesman) <=3, Salesman), ',')

Note : Replace Sales and Salesman with you actual fields, it will give you the Top 3 Salesman names as comma separated.

Hope this helps you.

Regards,

Jagan.

Re: top 3 salesmen in textbox

PradeepReddy — Tue, 11 Nov 2014 05:44:50 GMT

try something like this...

=concat(distinct IF(aggr(rank(sum(Sales)),Salesperson)<=3,Salesperson&CHR(13)))

Re: top 3 salesmen in textbox

Tue, 11 Nov 2014 06:02:43 GMT

hey amit,

your expression is not working.

cheers,

kunal bhattacharjee