Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
nesonica
New Contributor III

Customer Rating Logic

Hello everyone,

I am trying to rate my customers by points while:

Online Pieces %Pieces TotalOnline Sales %Sales TotalPoints
<=30%<=50<=20%<=20.0004
>30%>50>20%>20.0008
>40%>100>40%>40.00012
>50%>150>60%>80.00016
>60%>300>80%>200.00020
>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!