topic Count Number of Data Point in a Cluster in App Development

Count Number of Data Point in a Cluster

linnakry — Fri, 17 Feb 2023 09:38:36 GMT

Hi all,

I would like to count total number of data point belong to a cluster. In table below, column 4 is using KMeanCluster2D to cluster ID into 5 cluster. I want to count the number of ID belong to a cluster in Column 5.

Note: it should be a chart function.

I am trying to apply Silhouette Analysis to pick the K Value (although in my example, K value is already chosen).

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RankingFunctions/KmeansCentroidExample.htm

Re: Count Number of Data Point in a Cluster

brunobertels — Fri, 17 Feb 2023 12:11:19 GMT

may be this ?

=count(aggr(KMeans2D(vDistClusters,only(latitude),only(longitude)), nodistinct id))

=count( nodistinct aggr(KMeans2D(vDistClusters,only(latitude),only(longitude)), total id))

Re: Count Number of Data Point in a Cluster

linnakry — Fri, 17 Feb 2023 18:16:11 GMT

@brunobertels unfortunately it doesn't work.