topic Multiple Ranking in QlikView

Multiple Ranking

Wed, 19 Jan 2011 14:47:50 GMT

hello,

i have a table like the one below

Client Name	Region	Potential
Name1	NWC	4,230
Name2	NAM	3,948
Name3	NAM	2,958
Name1	FE	2,768
Name2	EMED	2,760
Name3	NAM	2,560
Name1	NAM	2,310
Name2	Aus/Nz	2,120
Name1	EMED	2,110
Name1	Aus/Nz	2,050
Name4	NWC	2,050
Name5	Aus/Nz	1,050
Total	Total	29,864

i want top three clients with top three Region some thing like below example

Client Name	Region	Potential
Name1	NWC	4,230
	FE	2,768
	NAM	2,310
Name2	NAM	3,948
	EMED	2,760
	Aus/Nz	2,120
Name3	NAM	2,958
Name3	NAM	2,560

iam using a straight table with two dimension [client name] and [Region] and the expression is

SUM(aggr(if(rank(sum(Potential))<=10,sum(Potential)),[Client Name]))

i tired to 2 - 3 combination but it only gives me only one sector.

appreciate your assistance

Multiple Ranking

Thu, 20 Jan 2011 10:15:35 GMT

Good Morning

Please assist.

Multiple Ranking

Mon, 10 Oct 2011 15:51:03 GMT

Try creating a table with two dimensions and one expression:
Dimension1 = aggr(if(rank(sum(Potential))<=3,[Client Name]), [Client Name])
Dimension2 = aggr(if(rank(sum(Potential))<=3,Region), Region)
Expression1 = sum(Potential)

Then supress null values on the dimensions.

Multiple Ranking

Wed, 12 Oct 2011 07:40:35 GMT

go to the sort tab, then sort according to:

expression: sum(potential) and make it as y-value: descending and max visible dimension as : 3

and make name and region as dimension.