Discussion Board for collaboration related to QlikView App Development.
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?
Check this app
View solution in original post
Try this as expression:
=aggr(if(Rank(sum(Sales))<=3,Sales),Sales) (For calculating Top 3)
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
For top 3 salesmasn:
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.
try something like this...
your expression is not working.