Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I'd suggest having a look at this:
https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-an-ABC-Analysis/ba-p/1472867
I'd suggest having a look at this:
https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-an-ABC-Analysis/ba-p/1472867