Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Chanty4u
Esteemed Contributor III

Re: RE:Same Top 10

not dimension limit.

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

gireesh1216
Contributor II

Re: RE:Same Top 10

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
Esteemed Contributor III

Re: RE:Same Top 10

Please look into my data and qvw

in excel sheet 3data

Re: RE:Same Top 10

What is the expected output?

sasikanth
Valued Contributor III

Re: RE:Same Top 10

Hi,

What do you want to achieve here?

Chanty4u
Esteemed Contributor III

Re: RE:Same Top 10

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?

Highlighted
Partner
Partner

Re: RE:Same Top 10

Hi,

Please find the below screenshot for using rank function

-Sathish

Partner
Partner

Re: RE:Same Top 10

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

-Sathish

Partner
Partner

Re: RE:Same Top 10

use if condition for top 5 or 10 values.

-Sathish

Chanty4u
Esteemed Contributor III

Re: RE:Same Top 10

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?