Rank In Pivot table with multiple dimensions

[#1]

Hello all,

I am trying to create a pivot table, how to showing the sales by rank based on all dimensions.

[#2]

Hi anji

please try following links

or Send Demo Data

Calculating TOP 10 VALUES in PIVOT TABLE

QlikView Blog Q-Tip #5 – Show Top Performers. Common but not too trivial. | Natural Synergies

Qlikview Bitz and Pieces: Top N records in Qlikview Straight/Pivot Tables and Charts

[sunilkumarqv]

these because of multiple dimensions

use only  only One Dimension - Customer ID then add Country in your Expression

it solve your problem

let me know if anything has to be corrected 

[#4]

Hi Sunil Kumar..

Thanks for giving reply..No But i want to include all the dimension .that is the original requirement..

So can u please give any other information regarding this...

[sunilkumarqv]

Go to Presentation tab-

check -Always fully Expanded option

[its_anandrjs]

Hi,

As i understand your expression

=Rank(TOTAL Aggr((Sum(Sales)), Country, Customer ID, Customer Name),0,1)

works fine in pivot also please clear your requirement it is some thing like

Country	Customer ID	Customer Name	Sales	Rank
France	Customer ID1	Customer 1	100	2
France	Customer ID2	Customer 2	50	3
France	Customer ID3	Customer 3	300	1
Germany	Customer ID4	Customer 4	400	1
Germany	Customer ID5	Customer 5	200	2

when selecting country

Hope this helps

Thanks & Regards

[#7]

hi anand this can be done this with this simple Formula

Aggr(Rank(Sum(Sales)),Country,[Customer Name])

[its_anandrjs]

Hi,

If this is your requirement do with this

=aggr(num(rank(sum(Sales),1)),Country,CustomerID)

Hope this helps

Thanks & Regards

[#9]

hi anji try this

this exactly giving output

Aggr(Rank(Sum(Sales)),[Customer Name])

i have attached Sample Application 

[#10]

Hi Anand,

Hi Gysbert,

Here i need just one record whose rank is "2" either PA001 or TA001,How can i achieve it ??