How to hard code an ABC analysis in script?

[t_guet01]

Hey guys,

I am following the https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-an-ABC-Analysis/ba-p/1472867 to perform an ABC analysis in work sheet mode. However, I would like to hard code an ABC-dimension in my data for customers.

I tried the following: creating a mapping table with CustomerID and the ABC dimension, based on the sales table. Code-wise it looks like this (I used the ABC code provided by Henric in the original post):

MappingABC:
Mapping Load
CustomerID,
Aggr( If((Rank(Sum(Net),1)-1) / Count(distinct total CustomerID)< 0.50, 'A',If((Rank(Sum(Net),1)-1) / Count(distinct total CustomerID)< 0.75, 'B', 'C')),CustomerID)
Resident Sales
Where year(Date)=2021 group by CustomerID;

However, Aggr & Rank do not work in the script, besides I didn't give any sorting order.

Does anyone know how this would work? I've only found dynamic topics in the forum, not this static option.

Thanks and best

T