Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
hope this helps:
regards
Marco
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
try to substitute with your actual fieldname.
regards
Marco
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?
Found it myself: x instead of 'x' (that was easy 🙂 )
How did you sort the table accordingly? With a formula?
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