How to do categorization of supplier based on year

[Qlik1Enthusiast]

Hello Qlik Gurus,

I have a requirement where i need to identify the suppliers based on the our purchasing volume yearly basis. For example , in 2022 the suppliers with whom we make 80 % of my purchases should be categorised as 'A' ,  rest 15 % as 'B' , else C.

I have written below statement in script and it is calculating overall purchase , but the requirement is to make it dynamic based on each year and also based on 80/20 principle instead of total net value.

Any idea how to do it.

IF(SUM(NetValue*ExchangeRate) > '50.000.000,00 ' ,'A', if(sum(NetValue*ExchangeRate) < '50.000.000,00 ' and sum(NetValue*ExchangeRate) > '1.000.000,00' ,'B', 'C')) as Vendor_Category

[Or · Accepted solution]

I'd suggest having a look at this:

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-an-ABC-Analysis/ba-p/1472867