topic Re: help with expression in QlikView

help with expression

adiarnon — Wed, 23 May 2018 06:02:35 GMT

in my purchase module

i have suppliers and the purchase order from each supplier

i wan to calculate-

whats the percentage of suppliers that constituting 80% of my purchase

what expression should I use?

tnx,

adi

Re: help with expression

kaushiknsolanki — Wed, 23 May 2018 06:04:24 GMT

Hi,

Check this.

Recipe for a Pareto Analysis – Revisited

Regards,

Kaushik Solanki

Re: help with expression

tresB — Wed, 23 May 2018 06:08:43 GMT

+ With a real example Re: Pareto Analysis

Re: help with expression

adiarnon — Wed, 23 May 2018 11:52:33 GMT

tnx,

its help but I still have a problem

i need the result in a text box not in a graph

in the example you gave me i can do-

Top 20% of the suppliers are worth 91.7% of total purchase

the expression give me the 91.7%

Num(Sum({<Central_BP = {"=Rank(Sum(USD_AMNT_BY_PO_RATE)) < (Count(TOTAL DISTINCT Central_BP)*0.20) + 1"}>}USD_AMNT_BY_PO_RATE)/Sum(USD_AMNT_BY_PO_RATE), '##.0%')

i need the opposite-

Top ??% of the suppliers are worth 80% of total purchase

how can i calculate the ??%

tnx.

adi