topic Re: Qlik and Python in QlikView

Qlik and Python

Tue, 27 May 2014 02:56:32 GMT

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

Tue, 27 May 2014 04:27:13 GMT

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

Thu, 29 May 2014 12:01:59 GMT

Thanks for the quick response (and English just fine). I think the other answer to my question was that its trivial to do, hence no specific posts.

Re: Qlik and Python

Tue, 03 May 2016 19:15:22 GMT

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