topic Re: Reorganise data ... in QlikView https://community.qlik.com/t5/QlikView/Reorganise-data/m-p/901980#M653749 <HTML><HEAD></HEAD><BODY><P>You're Welcome.</P></BODY></HTML> Mon, 13 Jul 2015 07:07:18 GMT 2015-07-13T07:07:18Z Reorganise data ... https://community.qlik.com/t5/QlikView/Reorganise-data/m-p/901977#M653746 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>No way to organize data like I need to feed this "directed diagramm" <A href="https://github.com/skokenes/QV_Ext-DirectedDiagram" title="https://github.com/skokenes/QV_Ext-DirectedDiagram">skokenes/QV_Ext-DirectedDiagram · GitHub !!!</A>‌</P><P>I have this table, describing different records associated with sources (of information) : </P><P></P><P>Table1 :</P><P>RecordId&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Source</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Web</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Email</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Web</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Web</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Email</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FTP</P><P></P><P>The record 1 is associated with 2 sources : Web" and "Email".</P><P></P><P>Now, I would like to evaluate the number of connected types through a Record.</P><P>Something like : </P><P></P><P>Node1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Node2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NbOfCommonRecorded</P><P>Web&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Email&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt; this line means 2 records have "Web" and "Email" as sources, here n°1 and 3</P><P>Web&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FTP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">=&gt; this line means 1 record has "Web" and "FTP" as sources, here n°3</SPAN></P><P>Email&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FTP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">=&gt; this line means 1 record has "FTP" and "Email" as sources, here n°3</SPAN></P><P></P><P>Of course, ideally, each unique couple should not be display twice since "web-email" and "email-web" are strictly the same.</P><P></P><P>Many thanks for your help ...</P></BODY></HTML> Tue, 07 Jul 2015 20:47:29 GMT https://community.qlik.com/t5/QlikView/Reorganise-data/m-p/901977#M653746 2015-07-07T20:47:29Z Re: Reorganise data ... https://community.qlik.com/t5/QlikView/Reorganise-data/m-p/901978#M653747 <HTML><HEAD></HEAD><BODY><P>PFA for solution.</P></BODY></HTML> Wed, 08 Jul 2015 08:42:54 GMT https://community.qlik.com/t5/QlikView/Reorganise-data/m-p/901978#M653747 2015-07-08T08:42:54Z Re: Reorganise data ... https://community.qlik.com/t5/QlikView/Reorganise-data/m-p/901979#M653748 <HTML><HEAD></HEAD><BODY><P>Hi kSindhuKannan,</P><P></P><P>That did the job ! Many thanks.</P><P>I'm still working on this solution to well understand it and accomodate it with all the context of my project and evolution coming soon but that's a good way to do.</P><P>Many thanks.</P><P></P><P>Gill</P></BODY></HTML> Fri, 10 Jul 2015 14:03:55 GMT https://community.qlik.com/t5/QlikView/Reorganise-data/m-p/901979#M653748 2015-07-10T14:03:55Z Re: Reorganise data ... https://community.qlik.com/t5/QlikView/Reorganise-data/m-p/901980#M653749 <HTML><HEAD></HEAD><BODY><P>You're Welcome.</P></BODY></HTML> Mon, 13 Jul 2015 07:07:18 GMT https://community.qlik.com/t5/QlikView/Reorganise-data/m-p/901980#M653749 2015-07-13T07:07:18Z