Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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?

29 Replies
Chanty4u
MVP
MVP
Author

not dimension limit.

For example:in same product i hve    two top 10 values?   which will give the result

gireesh1216
Creator II
Creator II

hello suri.......qlikview1.png

You have two products only.....product A,B

YOU CON'T FIND TOP 10 FOR 2 PRODUCTS

If You Have More then 10 products then only you can find top ten products......

Chanty4u
MVP
MVP
Author

Please look into my data and qvw

in excel sheet 3data

sunny_talwar

What is the expected output?

sasikanth
Master
Master

Hi,

What do you want to achieve here?

Chanty4u
MVP
MVP
Author

in my data

i hve  emp id  2  and yearsalry is 63000 for both    is hvng  two records so..  wen i use  dimen lim top 5  

how it is caluclates?

sathishkumar_go
Partner - Specialist
Partner - Specialist

Hi,

Please find the below screenshot for using rank function

-Sathish

sathishkumar_go
Partner - Specialist
Partner - Specialist

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

-Sathish

sathishkumar_go
Partner - Specialist
Partner - Specialist

use if condition for top 5 or 10 values.

-Sathish

Chanty4u
MVP
MVP
Author

that is okay.   in abve ur screen sht   

sales coordinator   sum(yearsalary)  65000

if i hve same   sales coordinator   sum(yearsalary)  65000

what will be the result?