topic Re: List box resrtiction ... in QlikView

List box resrtiction ...

Thu, 20 Mar 2014 14:06:53 GMT

HI All,

I have to show top 3 products which have top 3 sales in a year ,

Can anybody guide me How to write expression using rank() function..to get top 3 prodcuts ..

Regards

Nani

Gysbert_Wassenaar — Thu, 20 Mar 2014 14:12:34 GMT

aggr(only({<Product={'=rank(sum(Sales))<4'}>} Product),Product)

jonathandienst — Thu, 20 Mar 2014 14:18:08 GMT

To get the product name of the top 3 products, something like:

Top ranked:

=FirstSortedValue(Product, -Sum({<Year = {2014}>} Sales), 1)

2ns

=FirstSortedValue(Product, -Sum({<Year = {2014}>} Sales), 2)

3rd

=FirstSortedValue(Product, -Sum({<Year = {2014}>} Sales), 3)

HTH

Jonathan

EDIT: I see you want it in a list box. Use Gysbert's expression.

Fri, 21 Mar 2014 04:14:08 GMT

Hi , Gysbert it is not working ...

Regards

Nani

amit_saini — Fri, 21 Mar 2014 04:36:00 GMT

Hi Nani,

Please try this:

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

Thanks,