topic Similarity of Lists to each other as % in App Development https://community.qlik.com/t5/App-Development/Similarity-of-Lists-to-each-other-as/m-p/1602783#M63203 <P>I've got a number of revisions of an item with its constituent parts. I'd like to get a % similarity of each revision to the active revision. I'm assuming Advanced Analytics Toolbox will be used here to generate some sort of Correlation Coefficient. Here are two sample Revisions.</P><TABLE border="1"><TBODY><TR><TD>Bill of Material</TD><TD>Revision</TD><TD>Component</TD><TD>Weight</TD><TD>Active</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0001</TD><TD>Fender</TD><TD>7.5</TD><TD>N</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0001</TD><TD>Amp</TD><TD>15</TD><TD>N</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0001</TD><TD>Pick</TD><TD>.001</TD><TD>N</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Bill of Material</TD><TD>Revision</TD><TD>Component</TD><TD>Weight</TD><TD>Active</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0002</TD><TD>Dean</TD><TD>7.2</TD><TD>Y</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0002</TD><TD>Amp</TD><TD>15</TD><TD>Y</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0002</TD><TD>Pick</TD><TD>.001</TD><TD>Y</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0002</TD><TD>Songbook</TD><TD>.3</TD><TD>Y</TD></TR></TBODY></TABLE> Fri, 02 Apr 2021 08:01:14 GMT calebd 2021-04-02T08:01:14Z Similarity of Lists to each other as % https://community.qlik.com/t5/App-Development/Similarity-of-Lists-to-each-other-as/m-p/1602783#M63203 <P>I've got a number of revisions of an item with its constituent parts. I'd like to get a % similarity of each revision to the active revision. I'm assuming Advanced Analytics Toolbox will be used here to generate some sort of Correlation Coefficient. Here are two sample Revisions.</P><TABLE border="1"><TBODY><TR><TD>Bill of Material</TD><TD>Revision</TD><TD>Component</TD><TD>Weight</TD><TD>Active</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0001</TD><TD>Fender</TD><TD>7.5</TD><TD>N</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0001</TD><TD>Amp</TD><TD>15</TD><TD>N</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0001</TD><TD>Pick</TD><TD>.001</TD><TD>N</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Bill of Material</TD><TD>Revision</TD><TD>Component</TD><TD>Weight</TD><TD>Active</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0002</TD><TD>Dean</TD><TD>7.2</TD><TD>Y</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0002</TD><TD>Amp</TD><TD>15</TD><TD>Y</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0002</TD><TD>Pick</TD><TD>.001</TD><TD>Y</TD></TR><TR><TD>GuitarStarterPack</TD><TD>0002</TD><TD>Songbook</TD><TD>.3</TD><TD>Y</TD></TR></TBODY></TABLE> Fri, 02 Apr 2021 08:01:14 GMT https://community.qlik.com/t5/App-Development/Similarity-of-Lists-to-each-other-as/m-p/1602783#M63203 calebd 2021-04-02T08:01:14Z