3 Replies Latest reply: May 3, 2016 3:15 PM by Troy Dunaway RSS

    Qlik and Python

      I am looking at analytic integration for Qlik have seen multiple posts regarding integration with R.

       

      QlikView and R Integration for Predictive Analytics Example

      OpenCPU, R & QlikView Integration Example

      etc.

       

      I haven't been able to find anything similar with Qlik and Python either here or on the web generally. Does anyone have experience this or could they point me to posts I might have missed?

        • Re: Qlik and Python

          Hi, Francis.

          Simplest way to integrate scripting language with interpreter is using EXECUTE command in  QlikView script.

          For example:

           

          AggrSalesTable:

          LOAD

               Sum(Sales) as Sales,

               Date

          Resident MySalesTable

          Group By Date;

           

          Store AggrSalesTable into AggrSalesTable.csv(txt);

           

          EXEC {myScript}//This script using AggrSalesTable.csv calculate your data and store this data to CalculatedSalesData.csv;

           

          CalculatedSalesData:

          LOAD

               {MyCalculatedFields}

          From CalculatedSalesData.csv;

           

           

          Sorry, but my english so so

          • Re: Qlik and Python
            Troy Dunaway

            I am getting the following error:

             

            "Script line error:: return"

             

            when I am trying to run a python script from Qlik Sense editor. My code is below:

             

            execute C:\Finance\Finance Model\FE_Recodes.py;

             

             

            I have made the necessary changes in Settings.ini