Customer Rating Logic

nesonica — Tue, 16 Oct 2018 13:48:59 GMT

Hello everyone,

I am trying to rate my customers by points while:

Online Pieces %	Pieces Total	Online Sales %	Sales Total	Points
<=30%	<=50	<=20%	<=20.000	4
>30%	>50	>20%	>20.000	8
>40%	>100	>40%	>40.000	12
>50%	>150	>60%	>80.000	16
>60%	>300	>80%	>200.000	20
>70%	>600	-	-	24
>80%	>1500	-	-	27
>90%	>3000	-	-	30

Each column shall increase the "Total Points" according to its result, while every column is checked once. So a customer can get between 16 and 100 Points.

I would be grateful for any idea that helps me add the result of column one and two at least.

Thank you!

topic Customer Rating Logic in QlikView

Customer Rating Logic