Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
calebd
Partner - Contributor
Partner - Contributor

Similarity of Lists to each other as %

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.

Bill of MaterialRevisionComponentWeightActive
GuitarStarterPack0001Fender7.5N
GuitarStarterPack0001Amp15N
GuitarStarterPack0001Pick.001N

 

Bill of MaterialRevisionComponentWeightActive
GuitarStarterPack0002Dean7.2Y
GuitarStarterPack0002Amp15Y
GuitarStarterPack0002Pick.001Y
GuitarStarterPack0002Songbook.3Y
Labels (1)
0 Replies