how to do k clustering model in qlik sense

[dineshkumar_e]

Dear Qlik  specialists,

I am new to Qlik sense… i want to implement K clustering model in Qlik sense..Kindly help on same.

X axis = total pay-out amount

Y axis = age

No of K clusters = 6

Initial Range: 10000

Maximum Range: 1000000

Incremental value 10000 each

Initial Range: 10

Maximum Range: 100

Incremental value 1

Thanks

[balabhaskarqlik]

Check this:

Clustered and stacked bar chart in Qlik Sense

[d_ankusha]

Cluster means you want to have a grouped data?

[dineshkumar_e]

yes..We need grouped data.

thanks for reply.

[d_ankusha]

So you could try using nested if statements in script itself and then using Alias you can have it as a different field in the table itself.

[dineshkumar_e]

can you please share any sample code for understanding.

Thanks.

[d_ankusha]

okay, give me field name . and range for clusters

[dineshkumar_e]

Thanks Ankusha.. PFB

X axis = total pay-out amount

Y axis = age

No of K clusters = 6

Initial Range: 10000

Maximum Range: 1000000

Incremental value 10000 each

Initial Range: 10

Maximum Range: 100

Incremental value 1 .

[d_ankusha]

You can try this in your  script:

If(total pay-out amount  >=0 and total pay-out amount <10000,'Cluster1',

if(total pay-out amount >=10000 and total pay-out amount <20000,'Cluster2',

if(total pay-out amount >=20000 and total pay-out amount <30000,'Cluster3',

If(total pay-out amount >=30000 and total pay-out amount <40000,'Cluster4',

if(total pay-out amount >=40000 and total pay-out amount <50000,'Cluster5',

If(total pay-out amount >=50000 and total pay-out amount <60000,'Cluster6',

If(total pay-out amount >=60000 and total pay-out amount <70000,'Cluster7',

if(total pay-out amount >=70000 and total pay-out amount <80000,'Cluster8',

if(total pay-out amount >=80000 and total pay-out amount <90000,'Cluster9',

if(..."so on"..)))))

))))) as ClusterGroup

[agigliotti]

do you mean K-means clustering ?

if yes you need to use qlik sense analytic connection for R with Qlik Sense Server.