Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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?

Tags (2)
3 Replies
Not applicable

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

Not applicable

Re: Qlik and Python

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.

Not applicable

Re: Qlik and Python

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

Community Browser