topic Re: Python script(numpy & pandas) integration with Qliksense enetrprise in Integration, Extension & APIs

Python script(numpy & pandas) integration with Qliksense enetrprise

TanuGoel — Wed, 10 Aug 2022 07:11:25 GMT

Hi Qlik Users,

I have a python script written using numpy & pandas package. It writes the output in excel. Now , i want to use that script to show the output in qlik sense enterprise version. Please note that i only have enterprise access.

Could anyone please guide me with proper example and steps to follow.

Thanks in advance!

Re: Python script(numpy & pandas) integration with Qliksense enetrprise

Andrei_Cusnir — Wed, 10 Aug 2022 09:07:34 GMT

Hello,

If my understanding is correct, then you are using Python script to generate some data in EXCEL file and then you would like to display the generated data in Qlik Sense. Here are the steps that might help you get on the right path:

NOTE: You will have to keep in mind that Qlik Sense can't predict if your newly generated EXCEL file, will have new columns. So the structure should be the same. For example:

1. You have a Python script that is executed daily and does some forecasting and generates an EXCEL file with columns

As you can see the file is saved in a specific location:

2. We assume that the Python script will run and will either add more rows under Year, Value or will replace the rows with new value. BUT, you can't add more columns or remove columns, because then the script in Qlik Sense will have to be modified.

3. After that, you will have to go to Qlik Sense and inside Data load editor, create a new connection to the directory.

4. Now if you load the data you can create a table:

5. So lets assume that you have executed your Python script and the data was updated:

6. Reloading the Qlik Sense app, will give you:

7. In case your Python script creates files like this:

8. Then you can modify the script as follows:

As you can see we are using the Python to generate files/data and then we are using the Qlik Sense to display the generated data.

You can fully automate this by making the Python script update the data everyday at 9AM and then create a reload task that will reload the data in Qlik Sense every day at 10AM (or later).

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.

Re: Python script(numpy & pandas) integration with Qliksense enetrprise

TanuGoel — Thu, 25 Aug 2022 01:08:41 GMT

Hi Andrei,

Thanks for your reply.
This solution works fine if i already have a python output in some location but can there is a way that i trigger the Python script or .py file in qlik and it will show the output.

The requirement is to trigger the python script from qlik and output shall be displayed in qlik.

Thanks,
Tanu

Re: Python script(numpy & pandas) integration with Qliksense enetrprise

Manish_Kumar_ — Thu, 25 Aug 2022 18:10:59 GMT

Want to know the same!! (Python Integration with Qlik)
Appreciate if anybody could suggest the correct way to do so!

i.e. 1. Trigering python file from Qlik itself and then

2. using its output in Qlik and Displaying it in Frontend

topic Re: Python script(numpy &amp; pandas) integration with Qliksense enetrprise in Integration, Extension & APIs

Python script(numpy & pandas) integration with Qliksense enetrprise

Re: Python script(numpy & pandas) integration with Qliksense enetrprise

Re: Python script(numpy & pandas) integration with Qliksense enetrprise

Re: Python script(numpy & pandas) integration with Qliksense enetrprise

topic Re: Python script(numpy & pandas) integration with Qliksense enetrprise in Integration, Extension & APIs