Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Chanty4u
Esteemed Contributor III

RE:Same Top 10

hi all,

I have small doubt.

For example i hve  top 10 sales 100  for product "A"

and same for top 10   sales 100  for product"B"


i want to get top 10 sales ?

what will be the result?

1 Solution

Accepted Solutions
Partner
Partner

Re: RE:Same Top 10

=rank(aggr(sum([Year Salary]),Title))

-Sathish

29 Replies

Re: RE:Same Top 10

I don't really understand your question, would you be able to elaborate or share some sample data?

vsudhakar
Contributor III

Re: RE:Same Top 10

in dimension limit to give the largest value is 10

Chanty4u
Esteemed Contributor III

Re: RE:Same Top 10

hi,

  for below i want to get top10sales

productsales
a10
b10
a10
b10
a10
b10
a10
b10
a10
b10
a10
b10
a10
b10
a10
b10
a10
b10
a10
b10

Re: RE:Same Top 10

Hi,

When we load this data, because we have only 2 products we will get only top 2 products.

To get top 10 Products.

Just create a straight table with dimension as Product and use dimension limit tab to define top, and give expression as sum(Sales).

Regards,

Kaushik Solanki

Re: RE:Same Top 10

Hahahaha they all are the same, so my guess is that they should all be part of top 10 unless you don't want them to be.

balrajahlawat
Esteemed Contributor

Re: RE:Same Top 10

In this case you would be getting only 2 Product sales as you are having a & b product

Partner
Partner

Re: RE:Same Top 10

you can use rank function to get top values

-Sathish

Chanty4u
Esteemed Contributor III

Re: RE:Same Top 10

if i use rank function  for both top 10 means.....it will give 11 ?

Partner
Partner

Re: RE:Same Top 10

not understanding ur requirement properly.

1) You have 2 products each product you want top 10 sales? or u want to see the top 10 products based on the sales?

which is ur requirement?

please post sample data with ur requirement.

-Sathish