Dimension limit - sub dimension

[#1]

Hi,

i've got lost in the dimension limit

I have two dimension : Store, Seller  and one expression : total of sales per seller

i want in each of any store the top 2 sellers, how can i do that?

Thanks very muich,

Jacob

I.E

  input:

Store	Seller	Sales
A	X	23
A	C	34
A	V	13
A	B	45
B	N	52
B	M	60
B	L	17

Desired output

Store	Seller	Sales
A	C	34
A	B	45
B	N	52
B	M	60

[MayilVahanan]

Hi

Try like this

Dim: Store, Seller

Exp:

=if(Rank(Sum(Sales))<=2, Sum(Sales))

[sunny_talwar]

May be this:

Dimension: Store and Seller

Try this as your expression: =If(Rank(Sum(Sales)) <= 2, Sum(Sales))

Output:

[qlikviewwizard]

Hi Baruchja

Please follow Mayil's Advise.

[Anonymous]

goto Dimension Limit, select Dimension Seller and define first two

as you have only one Expression it Limit based on Sales

[#6 · Accepted solution]

Hi,

Please find the attached QVW

! !

[#7]

Hi try like below in expression,

=aggr(if( rank(sum(sales),4)<=2,sum(sales)), Seller)

[#8]

Thank you all!

how ever a strange act is when i have a third column which is for example seller name, and there are 2 sellers with the same name the solutions doesn't work in 100%