topic Re: Market Basket Analysis - QlikView integration with R in QlikView https://community.qlik.com/t5/QlikView/Market-Basket-Analysis-QlikView-integration-with-R/m-p/1013360#M936787 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I managed to find a simpler integration example where there is little coding in the QV macro.&nbsp; The method simply calls your R script and executes it</P><P></P><P>Regards.</P></BODY></HTML> Fri, 26 Feb 2016 09:21:20 GMT Anonymous 2016-02-26T09:21:20Z Market Basket Analysis - QlikView integration with R https://community.qlik.com/t5/QlikView/Market-Basket-Analysis-QlikView-integration-with-R/m-p/1013359#M936786 <HTML><HEAD></HEAD><BODY><P>I have had sight at two QV application on the community which integrate QV with R.&nbsp; I am trying to follow these to do market basket analysis (MBA) by passing records from my application to R for processing.&nbsp; I have the following scenario:</P><P></P><P><IMG alt="Screen Shot 2016-02-23 at 22.58.33.png" class="jive-image image-1" src="/legacyfs/online/115686_Screen Shot 2016-02-23 at 22.58.33.png" style="height: 242px; width: 620px;" /></P><P>User selects 'Therapeutic Subgroup' from the list box, and the results of the selections are displayed on the straight table on the right above.&nbsp; This data has ScriptNumber as a transaction identity and the Drug name being the item in the prescription basket.&nbsp; I now need to pass these values to R for MBA and do rules summary and plots.&nbsp; The attempted application is attached.&nbsp; I am able to connect to R but nothing else is happening with the macro.</P><P></P><P>The macro should also be able to prompt the user to select one 'Therapeutic Subgroup' from the list box and not more than one.</P><P></P><P>Kindly assist.</P><P></P><P>Regards.</P><P></P><P>Chris</P></BODY></HTML> Tue, 23 Feb 2016 21:15:36 GMT https://community.qlik.com/t5/QlikView/Market-Basket-Analysis-QlikView-integration-with-R/m-p/1013359#M936786 Anonymous 2016-02-23T21:15:36Z Re: Market Basket Analysis - QlikView integration with R https://community.qlik.com/t5/QlikView/Market-Basket-Analysis-QlikView-integration-with-R/m-p/1013360#M936787 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I managed to find a simpler integration example where there is little coding in the QV macro.&nbsp; The method simply calls your R script and executes it</P><P></P><P>Regards.</P></BODY></HTML> Fri, 26 Feb 2016 09:21:20 GMT https://community.qlik.com/t5/QlikView/Market-Basket-Analysis-QlikView-integration-with-R/m-p/1013360#M936787 Anonymous 2016-02-26T09:21:20Z