Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to automate the generation of a PDF report from one specific sheet in a Qlik Cloud app.
Currently, our manual monthly process is:
I am testing the Qlik Automate template “Send a simple multi-page report by email”.
I have configured Create Report with:
I then added an Add Sheet To Report block and linked the Report input to the output of the Create Report block.
However, when I go to:
Add Sheet To Report → Sheet → do lookup
the lookup remains on:
“Lookup is taking a while…”
and never returns the list of sheets.
The app itself is accessible to me and I can open/edit the required sheet normally.
My questions are:
Add Sheet To Report block instead of using do lookup?Create Report → Add Sheet To Report → Generate Report the recommended approach if I only want to generate a PDF from one specific Qlik sheet?Any advice or example automation would be really appreciated.
Thanks!
Hi all, good evening,
I need to compare the cumulative sales between a year and the year before. This for many years stored in my database.
The sales had already been normalized by the month of each year.
This is the expression I created to generate the information for each year:
Aggr(RangeSum(Above(Sum(QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])
| YEAR/MONTH | SALES YEAR | QTY |
| (other year months) | ... | ... |
| 2026/01 | 2024 | 1 |
| 2026/02 | 2024 | 10 |
| 2026/03 | 2024 | 25 |
| 2026/04 | 2024 | 8 |
| 2026/05 | 2024 | 14 |
| ... | ... | ... |
| 2026/01 | 2025 | 0 |
| 2026/02 | 2025 | 3 |
| 2026/03 | 2025 | 12 |
| 2026/04 | 2025 | 11 |
| 2026/05 | 2025 | 7 |
| ... | ... | ... |
| 2026/01 | 2026 | 4 |
| 2026/02 | 2026 | 5 |
| 2026/03 | 2026 | 8 |
| 2026/04 | 2026 | 12 |
| 2026/05 | 2026 | 20 |
And this is the generated graphic:
What I need is to created a new graphic that shows, for each year, the % growth between that year vs its last year, using the same rule (acumulated sales for each month).
I have already tried many solutions here in the topics, but I couldn't get the right result.
For exemple: Aggr(RangeSum(Above(Sum(QTY) / Sum({<[SALES YEAR] = {"$(=Only([SALES YEAR])-1)"}>}QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])
Thanks in advance for any help.
Hi All,
Qlik Sense repository service is consuming full memory in the server and causing node down.
Any idea why would repository service would consume full memory?
Current observation is repository service is gradually consuming full memory in the server. From resource monitor I could see that most memory is consumed while connecting to the dedicated postgres repository database.
Kindly provide any suggestion where should I start checking ?
Thanks.
Hello, we are using Qliksense Enterprise version 14.254.6. But some extensions like multi kpi, input variable, date picker are getting removed automatically and we need to ad them again and again. This issue occurs on frequent basis.Tried the solution suggested:Exclude the Qlik Sense folders from your antivirus scanning. This is the most frequent cause of recurring extension removal.
Multi node structure
Central, 2 Proxies, 2 Schedulers
Extensions are getting removed from QMC itself. It is not dependent on any specific activity. It happens randomly on daily basis.
Buen día, tengo una tabla dinamica donde la dimensión columna son los días del año, tengo la necesidad de dejar como vista predeterminada cuando se abra la hoja, la columna con fecha de ese día, quiero que sea la primera que sea visible del scroll y de ahi desplazar hacia atrás o hacia adelante, se puede ajustar de esta manera?
After a long wait, Qlik Cloud has finally introduced a feature that can save a LOT of time for developers! 🙌
When loading data, if a field is duplicated, Qlik now tells you exactly which field is causing the problem. 🎯
Before this update, I had to manually search for the duplicated field — and sometimes there were hundreds of fields to go through. 😩🔎
Now? Qlik simply shows you the exact name of the duplicated field. 💥
Less manual work.
Less frustration.
More time to focus on what really matters: building things. 👨💻⚡
This may look like a small improvement, but for anyone working with large data loads, it’s a BIG deal! 🚀
Wanted to flag this for anyone working with Qlik Automations: Qlik has added new automation-management tools to the Qlik MCP Server, along with a set of open-source Agentic Skills (qlik-oss/agentic-skills) that teach coding agents how to use them properly.
In this episode of Data Voyagers, I use Claude Code with the Qlik Automation Builder skill to create a Qlik Automation that reloads every Table Recipe in a Shared Space, then go back and edit it, testing along the way so you can see exactly what the agent does at each step.
If you're maintaining automations by hand today, or just want to see what an agent-built one actually looks like under the hood, it's worth the 19 minutes.
Watch it here: https://youtu.be/FwgpjHETWHU
The skills are open source and on GitHub if you want to try them in your own tenant.
Regards,
Mark Costa
What Makes Someone a Featured Member in the Qlik Community?
I’ve been exploring the Qlik Community recently and noticed the Featured Members section. It made me curious about what actually makes someone stand out enough to be recognized by the community. Is it mainly based on technical knowledge, the number of questions they answer, or the quality of their contributions?
I’m especially interested in learning whether Featured Members are selected because they help other users solve problems, share useful tutorials, participate in discussions, or contribute to the wider Qlik ecosystem. For someone who is still building their knowledge of data analytics and business intelligence, understanding this would be really helpful.
I also spend time exploring data analytics, business intelligence, digital tools, and technology-related topics through websites. I’d love to know whether participating in communities like Qlik can also help people improve their professional knowledge and discover useful resources.
What do you think makes a Qlik Community member truly valuable? Are there any specific achievements, contribution levels, or qualities that usually lead to Featured Member recognition
Good day Qlik Community,
Allow me to go really off-topic here, but I am glad to announce that today I am launching a new book:
The English version:
The Handprint and the Algorithm
From the Cave Wall to the Machine Mind
The Portuguese version:
A Marca da Mão e o Algoritmo
Das pinturas nas cavernas às máquinas que pensam
It is a book about AI, but not exactly technical. It discusses the philosophy and impact of AI, from a historical and sociological aspect, showing in between the history of human invention, where we came from and where we are going to.
We think this discussions are new, but we always had them. Since Socrates claiming writing will destroy human memory to us, saying AI will kill our ability to create.
More information about the book can be found on Data Voyagers or on my website:
The Cave Wall and the Machine Mind
https://igoralcantara.com/handprint
Here’s your agentic AI readiness check. (Got Qlik? You're closer than you think.)
Walk through six new AI capabilities now generally available in Qlik and start applying agentic data engineering to your team’s workflows.
Set your course for six weeks of expert-led sessions on data, analytics, and AI — available on demand.
Built for the builders: Modern data engineering is AI powered — and engineer led.
The pilot-to-production gap is real. From fragmented data to governance gaps Qlik and AWS break down what’s holding your enterprise AI back — and how to solve them.
Your journey awaits! Join us by Logging in and let the adventure begin.