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!

[swuehl]

Not really sure what you are asking for.

In general, the relations should be visible just using Qlik's associative DB in, i.e. if you select a task, you will see all related e.g. people and non-related people will be removed / greyed out.

If you are asking for a special kind of visualization, maybe like this?

Informative, Curvy & Never Before Seen (by me at least) – The Associated Curve Chart | QVDesign

or this

Brilliant Qlikview Parallel Co-Ordinates Chart | QVDesign

(but both are rather complex charts to create)

[swuehl]

If you are looking for special visualization, here are some more examples using extensions

Visualization of Graph Data

But again, all these  and the development aspects behind are not really chart objects for starters.

[#4]

Thank you!

[engishfaque]

Dear QlikNewBy,

Please check,

AND and OR

And Mode - YouTube

Kind regards,

Ishfaque Ahmed

[swuehl]

You are welcome (though still not sure which part of my answer was valuable to you).

If your question is answered, please consider closing this thread by marking helpful or correct answers.

Qlik Community Tip: Marking Replies as Correct or Helpful

[MarcoWedel · Accepted solution]

Hi,

you could present the relation between projects and project members as a pivot table:

In order to accentuate groups of people working in similar projects as well as projects sharing the same members you could sort the project and project member dimensions accordingly:

Please find attached a (rather inefficient 😉 example application.

I tried to create a score that accumulates the differences between neighbouring rows and columns to find a sequence with minimal changes thus creating groups in the chart.

Maybe someone can come up with an optimization algorithm that performs better than the included brute force attempt to create the order sequence ...

hope this helps

regards

Marco

[#8]

Thank you very much!!

[MarcoWedel]

You're welcome.

Please close your thread if your question is answered or explain if the proposed solutions do not solve your problem.

Thanks

Regards

Marco

[#10]

Since I am using Qlik Sense Desktop now, I am unable to open your qvw.

How can I make an "x" in the pivot table?