Community Detection

[#1]

Hey everybody,

Is there a Qlik way how to detect groups within a set of data? Let's say you have 100 people working on different projects. How can I visualize who works together on which task?

Thanks a lot!

[MarcoWedel]

Hi,

hope this helps:

regards

Marco

[#3]

Hi Marco,

I do not have this template since I am using QlikSense, but if I uae the formula as key figure in my pivot table, it would say that I inserted the wrong fieldname.

Regards

[MarcoWedel]

try to substitute with your actual fieldname.

regards

Marco

[#5]

I of course did. 😉

Is there a certain way how the data has to be provided in order to be able to use that formula?

[#6]

Found it myself: x instead of 'x' (that was easy 🙂 )

How did you sort the table accordingly? With a formula?

[MarcoWedel]

Hi,

I used sorting expressions like this:

SubStringCount(Left(ProjMembPermut,Index('/'&ProjMembPermut&'/','/'&ProjectMemberID&'/')),'/')

SubStringCount(Left(ProjPermut,Index('/'&ProjPermut&'/','/'&ProjectID&'/')),'/')

Please find attached a Sense example.

hope this helps

regards

Marco