i need to deliver an XLS, which contains a simple pivot table automatically to a dedicated recipient. The pivot table exists an app. We do not have the XLS plug in to connect directly from QExcel to Qlik Sense, hence my idea was to create an automation, which gets the pivot table's data and puts it in a spreadsheet, then save the spreadsheet and send it by email to the recipient. How would i do this using an automaion ?
Hello, Don’t stream directly into Qlik. Qlik is very fast for analytics, but it’s not designed to ingest raw IoT events continuously.
Best approach:
Sensors (ESP32, Arduino, Raspberry Pi) send data via HTTP or MQTT A small ingestion layer (Node-RED, lightweight API, etc.) receives it Data is stored in a database or time-series store (Postgres, SQL Server, InfluxDB) Qlik reads from that store in a controlled way This keeps dashboards fresh without overloading the Qlik engine.
Now how to keep dashboards “near real time” Use Incremental reloads (most common)
Qlik reloads only new rows every few minutes Data is stored in QVDs Very stable, cheap in resources Perfect if 1–5 minutes latency is acceptable This is the default choice for most IoT dashboards. regards,
First of all don't over complicate things, contact your Office 365 administrator and your Qlik Administrator and look into getting the Excel plugin, you have to configure some things in Qlik Cloud and then add the manifest to Office. A report built with the Excel plugin should do exactly what you are proposing without having to learn the intricacies of the Excel API.
It sounds to me like you don't have much experience with automations so start by just writing the output from the chart to the output window, this will give you an idea of how the qlik api works.
There are some templates that write data to Excel, bring those into your personal space and see if you can make them work. once working modify them to see what you can do.
