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