Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
behdadian
New Contributor

Customer segmentation using avg & stdev

Hello,

I'm still a nooby in Qlikview. I'm recently trying to do some basic customer segmentation. I'm trying to compare each customer's total sales with total average, then create a binary High/Low value (High if above total average and low  if else). I tried using:

if(Sum(sales)>=avg(aggr(sum(sales) , customer-code)),'High','Low')

but i didn't get the result that I wanted. Using TOTAL didn't help either. So instead I had to use:

if(sum(sales)>=(Sum(Total sales)/Count(Total DISTINCT customer-code)),'High','Low')

which works but it's not pretty at all! and also does not help me in my future segmentation. In the next step I'd like to segment customers in 3 segments: very high, high, low. I need something like this:

if(sum(sales)> average of all customers + 2 stdev of all customers, 'very high',

     if(sum(sales) > average of all customers  and sum(sales)<average of all customers + 2 stdev of all customers,'high',

               'low')

Thanks in advance

Ali

Community Browser