Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

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
sathishkumar_go
Partner - Specialist
Partner - Specialist

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

-Sathish

View solution in original post

29 Replies
sunny_talwar

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

Anonymous
Not applicable

in dimension limit to give the largest value is 10

Chanty4u
MVP
MVP
Author

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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
sunny_talwar

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.

Anonymous
Not applicable

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

sathishkumar_go
Partner - Specialist
Partner - Specialist

you can use rank function to get top values

-Sathish

Chanty4u
MVP
MVP
Author

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

sathishkumar_go
Partner - Specialist
Partner - Specialist

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