Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion III
Champion 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
Highlighted
Partner
Partner

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

-Sathish

View solution in original post

29 Replies
Highlighted

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

Highlighted
Creator III
Creator III

in dimension limit to give the largest value is 10

Highlighted
Champion III
Champion III

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
Highlighted
MVP & Luminary
MVP & Luminary

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted

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.

Highlighted
Champion
Champion

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

Highlighted
Partner
Partner

you can use rank function to get top values

-Sathish

Highlighted
Champion III
Champion III

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

Highlighted
Partner
Partner

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