Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

cluster my sales into four categories

hi all,

trying to cluster my sales into four categories where the categories will be 0 to %25, %26 to %50, %51 to %75 and %76 to %100.

anyone knows what logic I can use?

9 Replies
sunny_talwar

These percentages are by products or areas or employees? In essence, what is going to be your dimension/s?

alec1982
Specialist II
Specialist II
Author

trying to do several scenarios..  Day, City, Customer... and trying to build K means similar to the ones in excel. and the pcts are pcts of sales.

sunny_talwar

It needs to look something like this

Aggr(

     If(Sum(Sales)/Sum(TOTAL Sales) <= 0.25, Dual('0% to 25%', 1),

     If(Sum(Sales)/Sum(TOTAL Sales) <= 0.5, Dual('25% to 50%', 2),

     If(Sum(Sales)/Sum(TOTAL Sales) <= 0.75, Dual('50% to 75%', 3),

     If(Sum(Sales)/Sum(TOTAL Sales) <= 1, Dual('75% to 100%', 4)))))

, YourDimensions)

alec1982
Specialist II
Specialist II
Author

I might not explained it right.. I am trying to find a sample in qlikview to do K means as this site

Possibly the simplest way to explain K-Means algorithm

alec1982
Specialist II
Specialist II
Author

I dont think I explained it right.. the request I have is to do K means.. tried to add sample webs here but it is being moderated..

Any one has a sample of K means algorithm?

sunny_talwar

Sorry I have never heard that before. Somebody else might be able to help better

alec1982
Specialist II
Specialist II
Author

they have approved my sample and it is available to view on one of my comments..

I appreciate any help

MarcoWedel

please provide some sample data and your expected result.

DavidFoster1
Specialist
Specialist

K-Means is a data science / predictive analytics technique. QlikView will not be able to do this kind of iterative clustering algorithm. You would need to look at incorporating an R module.

Have a look at: QlikView and R Integration for Predictive Analytics Example