#53 👨‍🔬 Creating Clusters in Qlik Sense

👨‍🔬 Creating Clusters in Qlik without R ? Yes ! Using Kmeans in Sept 2020 release



You know, I used to say I'm not a tech guy. I don't know more about data science than most people do. I've tried some R courses, but it doesn't fit for me

So last Wednesday when a customer asked me to integrate R to make clusters from a point cloud I was like 😓

Do you believe in destiny, chance or coincidence?


I had lunch with my friend Baptiste, talking about this and that on Qlik and that thing about R.

He says me "did you try the new Kmeans() in Sept 2020 "

I didn't read the full release note 🙄 Go I stop talking about my life


Create clusters and color dimensions with Kmeans2D() and Input variable 🧙‍♂️

Clustering is a nice way to color code dimensions or to create calculated dimensions without class()


⁉ How To ⁉

First, initiate a variable vNoCluster to define the number of clusters

In my ScatterPlot, each point is a Post with Views and Likes
Set Colors by Expression with :

KMeans2D($(vNoCluster),sum(Like),sum(View))

Nice way to add color no ?

Then create dimensions with :

=aggr(
KMeans2D($(vNoCluster),sum(Like),sum(View)),
[# No]) // Post identifier

Cheers