topic Re: Dimension limit - sub dimension in QlikView

Dimension limit - sub dimension

Wed, 12 Aug 2015 06:36:08 GMT

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

Re: Dimension limit - sub dimension

MayilVahanan — Wed, 12 Aug 2015 06:39:08 GMT

Try like this

Dim: Store, Seller

Exp:

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

Re: Dimension limit - sub dimension

sunny_talwar — Wed, 12 Aug 2015 06:41:39 GMT

May be this:

Dimension: Store and Seller

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

Output:

Re: Dimension limit - sub dimension

qlikviewwizard — Wed, 12 Aug 2015 06:41:42 GMT

Hi Baruchja

Please follow Mayil's Advise.

Re: Dimension limit - sub dimension

Anonymous — Wed, 12 Aug 2015 06:42:16 GMT

goto Dimension Limit, select Dimension Seller and define first two

as you have only one Expression it Limit based on Sales

Re: Dimension limit - sub dimension

Wed, 12 Aug 2015 06:44:57 GMT

Hi,

Please find the attached QVW

! !

Re: Dimension limit - sub dimension

Wed, 12 Aug 2015 06:46:02 GMT

Hi try like below in expression,

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

Re: Dimension limit - sub dimension

Wed, 12 Aug 2015 07:58:41 GMT

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%