topic Re: Rank In Pivot table with multiple dimensions in QlikView

Rank In Pivot table with multiple dimensions

Sat, 22 Mar 2014 05:04:16 GMT

Hello all,

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

Re: Rank In Pivot table with multiple dimensions

Sat, 22 Mar 2014 06:40:48 GMT

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

Re: Rank In Pivot table with multiple dimensions

sunilkumarqv — Sat, 22 Mar 2014 06:50:22 GMT

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

Re: Rank In Pivot table with multiple dimensions

Sat, 22 Mar 2014 07:11:00 GMT

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...

Re: Rank In Pivot table with multiple dimensions

sunilkumarqv — Sat, 22 Mar 2014 07:19:21 GMT

Go to Presentation tab-

check -Always fully Expanded option

Re: Rank In Pivot table with multiple dimensions

its_anandrjs — Sat, 22 Mar 2014 07:23:38 GMT

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

Re: Re: Rank In Pivot table with multiple dimensions

Sat, 22 Mar 2014 07:32:02 GMT

hi anand this can be done this with this simple Formula

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

Re: Re: Rank In Pivot table with multiple dimensions

its_anandrjs — Sat, 22 Mar 2014 07:43:02 GMT

Hi,

If this is your requirement do with this

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

Hope this helps

Thanks & Regards

Re: Rank In Pivot table with multiple dimensions

Sat, 22 Mar 2014 07:58:28 GMT

hi anji try this

this exactly giving output

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

i have attached Sample Application

Re: Rank In Pivot table with multiple dimensions

Thu, 21 May 2015 16:31:10 GMT

Hi Anand,

Hi Gysbert,

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