https://community.qlik.com/t5/App-Development/Compare-customers-with-a-similar-purchasing-profile/m-p/1786510#M61338 <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b"><SPAN>I have three related tables:</SPAN></SPAN> </SPAN></P><P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b"><SPAN>- Sales,</SPAN></SPAN><BR /><SPAN class="JLqJ4b ChMk0b"><SPAN>-Customers (associated with the customer number with sales),</SPAN></SPAN><BR /><SPAN class="JLqJ4b ChMk0b"><SPAN>- Products (associated product number with sales).</SPAN></SPAN> </SPAN></P><P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b"><SPAN>The customer table shows customer details.</SPAN></SPAN><BR /><SPAN class="JLqJ4b ChMk0b"><SPAN>The product table contains various data on products, including the product group that is important for us from the point of view of the case.</SPAN></SPAN> </SPAN></P><P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b"><SPAN>I wonder how to make a model that (after selecting a given customer), in addition to selling in a given period, will show data about other customers with a similar purchasing profile (i.e. those who most often buy products in the most similar product groups).</SPAN></SPAN> </SPAN></P><P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b"><SPAN>Do you have any idea?</SPAN></SPAN></SPAN></P> Sat, 16 Nov 2024 17:26:37 GMT qlikeers 2024-11-16T17:26:37Z https://community.qlik.com/t5/App-Development/Compare-customers-with-a-similar-purchasing-profile/m-p/1786510#M61338 <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b"><SPAN>I have three related tables:</SPAN></SPAN> </SPAN></P><P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b"><SPAN>- Sales,</SPAN></SPAN><BR /><SPAN class="JLqJ4b ChMk0b"><SPAN>-Customers (associated with the customer number with sales),</SPAN></SPAN><BR /><SPAN class="JLqJ4b ChMk0b"><SPAN>- Products (associated product number with sales).</SPAN></SPAN> </SPAN></P><P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b"><SPAN>The customer table shows customer details.</SPAN></SPAN><BR /><SPAN class="JLqJ4b ChMk0b"><SPAN>The product table contains various data on products, including the product group that is important for us from the point of view of the case.</SPAN></SPAN> </SPAN></P><P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b"><SPAN>I wonder how to make a model that (after selecting a given customer), in addition to selling in a given period, will show data about other customers with a similar purchasing profile (i.e. those who most often buy products in the most similar product groups).</SPAN></SPAN> </SPAN></P><P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b"><SPAN>Do you have any idea?</SPAN></SPAN></SPAN></P> Sat, 16 Nov 2024 17:26:37 GMT https://community.qlik.com/t5/App-Development/Compare-customers-with-a-similar-purchasing-profile/m-p/1786510#M61338 qlikeers 2024-11-16T17:26:37Z https://community.qlik.com/t5/App-Development/Compare-customers-with-a-similar-purchasing-profile/m-p/1786620#M61348 <P>Please upload some sample data and expected output for faster response.</P> Fri, 26 Feb 2021 14:12:33 GMT https://community.qlik.com/t5/App-Development/Compare-customers-with-a-similar-purchasing-profile/m-p/1786620#M61348 Saravanan_Desingh 2021-02-26T14:12:33Z