topic Re: Top 3 sales!!!!!!!!!!!! in QlikView

Top 3 sales!!!!!!!!!!!!

Thu, 20 Mar 2014 14:54:52 GMT

Hi All,

I have a sales table and department table ...my question is i have to display top 3 sales in list box and write expression in front end dont want write in edit script

pls help me

Re: Top 3 sales!!!!!!!!!!!!

MK_QSL — Thu, 20 Mar 2014 15:09:14 GMT

Create a list box

write below in expression

IF(Aggr(Rank(SUM(Sales),4),Department)<=3, Department)

IF(Aggr(Rank(SUM(Sales),4),Department)<=3, SUM(Sales))

IF(Rank(SUM(Sales),4)<=3, SUM(Sales)

Re: Top 3 sales!!!!!!!!!!!!

Gysbert_Wassenaar — Thu, 20 Mar 2014 15:11:26 GMT

Choose Expression for the listbox instead of a field and use as expression something like

aggr(only({<DepartmentID={'=rank(sum(SalesAmount))<=3'}>} DepartmentID),DepartmentID)

Replace DepartmentID and SalesAmount with the real field names of your document.

Re: Top 3 sales!!!!!!!!!!!!

Thu, 20 Mar 2014 15:53:34 GMT

Hi manesh ,

thanku for rly

when click in dept list object it will show the top sales in sales object .

i dont want like that just i want see the top 3 sales in list object only top 3

pls help me

Re: Top 3 sales!!!!!!!!!!!!

MK_QSL — Thu, 20 Mar 2014 15:55:51 GMT

Top 3 Sales with respect to what? which field ?

Re: Top 3 sales!!!!!!!!!!!!

Thu, 20 Mar 2014 15:57:55 GMT

with respect dept in sales field