How to create Rank range filter and further display straight table

[vinod2086]

Need to create List box with

Ranks

Rank(1-20)

Rank(21-40)

Rank(41-80)

Rest all

when i select Rank(1-20)....straight table should  display list of 1-20 records as below , when i select 21-40 it should display 21-40.....same as follows

And i am also not able to Rank numbers in first column    

Rank	Region	Sales(Million)	BranchCode
	Norht1	$949.26	BR151
	Norht1	$942.91	BR030
	East3	$669.36	BR050
	East2	$497.81	BR055
	West2	$475.94	BR080
	East1	$454.74	BR067
	South2	$409.50	BR025
	South1	$328.77	BR044
	South2	$298.48	BR082
	East3	$238.30	BR018

[sunny_talwar]

Do you want this on the front end of the application? or can you create this in the script also?

[vinod2086]

Thanks Sunny for ur quick response

I need to create in Front end

[sunny_talwar]

This might be doable if you are using QV12.10 or later

Recipe for a Pareto Analysis – Revisited

[vinod2086]

Yes using QV12.10

[#6]

For rank u try this one in table

aggr(rank([Sales(Million)]),BranchCode)

[sunny_talwar]

Check if the attached is what you need

[effinty2112]

Hi,

     Try a listbox with this expression:

=Aggr(

Pick(

Match(

-1,

Rank(Sum({1}Sales)) <=20,

Rank(Sum({1}Sales)) <=40,

Rank(Sum({1}Sales)) <=80,

-1),

'Rank(1-20)',

'Rank(21-40)',

'Rank(41-80)',

'Rest all'),

BranchCode)

Set the sort order to text A=>Z.

Good luck

Andrew