Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
mercesletifer
New Contributor

Qlik Sense Desktop Integration with Python

Hi everyone

I want to ask some questions about discussion titile.

I am going to forecast time series analysis and i can create a graph and achieve that goal via Jupyter Notebook.

I did it via R with Advanced Analytic Tools in ARIMA Forecast but  I need to do it with Python.

1) how can I integrate python to my qlik sense ?

2) how can i bring my graph to qlik sense

My python codes is in attachment.

Thank you for your help. Best regards

import pandas as pd

from fbprophet import Prophet

import matplotlib.pyplot as plt

plt.style.use('fivethirtyeight')

df = pd.read_csv('AirPassengers.csv')

df.head(5)

df['Month'] = pd.DatetimeIndex(df['Month'])

df = df.rename(columns={'Month': 'ds',

   'AirPassengers': 'y'})

daily_seasonality=True
my_model = Prophet(interval_width=0.95)

my_model.fit(df)

future_dates = my_model.make_future_dataframe(periods=48, freq='MS')

future_dates.tail()

forecast = my_model.predict(future_dates)

forecast[['ds', 'yhat']].tail()

my_model.plot(forecast,

   uncertainty=True)

2 Replies
MVP
MVP

Re: Qlik Sense Desktop Integration with Python

You can use the feature of Qlik Sense that was introduced in Qlik Sense June 2017 called Advanced Analytics Integration. AAI has it's own forum site her on Community: Advanced Analytics Integration

R and Python were the first languages that had full examples on how to integrate with. There are lots of videos and documentation on how to do it at the forum site.

The integrations are released as open source even though the basic communication feature that ties directly into the expressions in Qlik Sense are generic (Server Side Extensions).

Link to Github and the Python AAI: GitHub - qlik-oss/server-side-extension: A Qlik server-side extension protocol for extending the Qli...

One important thing though is that the AAI is focused on getting data integration first and foremost. So you will not find examples I believe on bringing graphs/plots over with the AAI. There shouldn't be a problem implementing it though - but it wont be out of the box.

Anyway if the plot is something you can use the charts in Qlik Sense instead it will be easy to transfer the dataframe and do the graphing in Qlik Sense.

fhoebechanapl
New Contributor II

Re: Qlik Sense Desktop Integration with Python

Hi Peter

Will we be able to use AAI on the free Desktop version?

Thanks.