Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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.
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