Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vinod2086
Contributor II

How to create Rank range filter and further display straight table

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    

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

Re: How to create Rank range filter and further display straight table

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

vinod2086
Contributor II

Re: How to create Rank range filter and further display straight table

Thanks Sunny for ur quick response

I need to create in Front end

Re: How to create Rank range filter and further display straight table

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

Recipe for a Pareto Analysis – Revisited

vinod2086
Contributor II

Re: How to create Rank range filter and further display straight table

Yes using QV12.10

Not applicable

Re: How to create Rank range filter and further display straight table

For rank u try this one in table

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

Re: How to create Rank range filter and further display straight table

Check if the attached is what you need

Highlighted
effinty2112
Honored Contributor

Re: How to create Rank range filter and further display straight table

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