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

How to create Rank range filter and further display straight table

vinod2086 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

sunny_talwar — Tue, 29 Aug 2017 11:53:58 GMT

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

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

vinod2086 — Tue, 29 Aug 2017 12:06:24 GMT

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

sunny_talwar — Tue, 29 Aug 2017 12:07:05 GMT

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

Recipe for a Pareto Analysis – Revisited

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

vinod2086 — Tue, 29 Aug 2017 12:13:26 GMT

Yes using QV12.10

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

Tue, 29 Aug 2017 12:18:05 GMT

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

sunny_talwar — Tue, 29 Aug 2017 12:30:36 GMT

Check if the attached is what you need

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

effinty2112 — Tue, 29 Aug 2017 13:08:41 GMT

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