Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

top 3 salesmen in textbox

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

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

7 Replies
anbu1984
Master III
Master III

Check this app

amit_saini
Master III
Master III

Kunal ,

Try this  as expression:

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


Thanks,
AS

SergeyMak
Partner - Specialist II
Partner - Specialist II

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

Regards,
Sergey
amit_saini
Master III
Master III

For top 3 salesmasn:

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

Thanks,
AS

jagan
Luminary Alumni
Luminary Alumni

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.

PradeepReddy
Specialist II
Specialist II

try something like this...

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

Not applicable
Author

hey amit,

your expression is not working.

cheers,

kunal bhattacharjee