QlikView App Dev

[#1]

Hi all,

I am using the following calculated dimension:

=Aggr(If(Rank($(eCurrentYTD))<=10, [Account Name]),[Account Name])

i did use the supress null value

I have 2 separate sections in my QlikView tab where a similarly calculated dimension is being used.  One section shows top 10, the other section only shows top 9.  How do i fix this to show top 10 at all times?

Account Name	YTD ASP ( USD)	YTD Growth %	QTD ASP ( USD)	QTD YoY %	QTD QoQ %
Partner a	44,577,926	21.5444721	12,715,686	45.6331612	-17.9268021
Partner b	26,290,933	7.75065087	9,962,665	46.0793291	57.6985816
Partner c	18,269,092	10.4196033	5,036,342	-6.8167799	3.59499242
Partner d	17,521,613	19.0968427	3,747,405	4.1837083	-31.3628837
Partner aa	16,856,541	20.6610431	4,429,382	6.46526097	6.27342516
Partner bb	15,685,435	14.8085404	3,380,236	-1.7317269	-44.2987118
Partner cc	15,441,650	-10.0352646	3,087,987	-43.354988	-7.86946907
Partner dd	14,107,089	-10.1109644	3,842,195	-37.749881	-14.0286291
Partner f	13,556,765	7.79454101	4,478,060	-15.220788	-10.1520601
Top 10 Total	182,307,044	10.221814	50,679,959	3.3042334	-3.379356

[sunny_talwar]

How about when you do this:

=Aggr(If(Rank($(eCurrentYTD)) < 11, [Account Name]),[Account Name])

[#3]

I tried that and it didn't work.  still only showing 9

[vinieme12]

=Aggr(If(Rank($(eCurrentYTD),1,1)<=10, [Account Name]),[Account Name])

[sunny_talwar]

Can you use this as your expression to check which Account is Rank 10

Rank($(eCurrentYTD))