How to do 80-20 Rule in QlikView

[#1]

Hi All,

I am having a scenario for creating 80-20 rules.If any body having qvw for the same please share with me.

[#2]

Hi,

please see the example. It provides hopefully the information you need.

Good Luck!

Rainer

[#3]

I use this formula, but is 20 customers, not 20%...

=

'80/20

&

num

(

sum

(total <Period,CONCERN_NAME> aggr

(

if

(

rank

(sum(SALESAMOUNT))<=

20

,

sum

(OMZET

))

,

CONCERN_NAME

))

/

sum

(total SALESAMOUNT

)

,

'###.##0,00%', ',' , '.'

)

[#4]

Wouter,

I think you should set up a 20% count on the customerID. So your expression would then look like:

--------------------------------------------------------------------------------------------------------------

=

'80/20

&

num(

sum(total <Period,CONCERN_NAME> aggr

(if

(rank

(sum(SALESAMOUNT))<= (count(distinct CONCERN_NAME_ID)*0.2)

, sum

(OMZET

))

,CONCERN_NAME

))

/

sum(total SALESAMOUNT )

,

'###.##0,00%', ',' , '.'

)

--------------------------------------------------------------------------------------------------------------

I hope this will help you.

[jafari_ervin]

Now you can do this with dimension limit in qlikview 11.