Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
These percentages are by products or areas or employees? In essence, what is going to be your dimension/s?
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.
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)
I might not explained it right.. I am trying to find a sample in qlikview to do K means as this site
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?
Sorry I have never heard that before. Somebody else might be able to help better
they have approved my sample and it is available to view on one of my comments..
I appreciate any help
please provide some sample data and your expected result.
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