Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

3 Replies
Not applicable
Author

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
Author

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
Author

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