Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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