Hey folks, I’m dealing with a transactional table where the first entries are the initial investments, and the rest may be other types of transactions. But with the transaction codes 'TC00402' quite narrows it.

I want to pull out just those initial investments by looking at the earliest date for each account. Some accounts only have one record, while others have multiple entries on the same date.

How would you go about separating these in the script? Would love any tips or approaches!

I’ve been using Qlik Reporting recently and often find myself struggling in several areas:

• Locating images I’ve added to the image library.
• Debugging deployments to identify where images have been used.
• Understanding error messages, which often lack clarity.

The most frustrating part isn’t just finding the right images—it’s even harder to delete unwanted ones. Before removing an image from the library, I must first delete every instance where it’s deployed. However, templates don’t display image icons, so I have to click into properties and check image sources manually. Imagine doing this for 50+ images in a template—it feels like one step forward, ten steps back.

When I used NPrinting, the process was much simpler. If Storytelling had the 'LEVEL' similar functionality, it would save us significant time and effort.

Challenges and Suggestions

Below are the issues I’ve encountered. I hope these are not inherent limitations but rather gaps in my understanding or missing guidelines.

Problem	Challenges	Better Alternative Suggestion by Qlik or Other Qlik Reporting Expert from Community
Adding Images – One by One	Adding multiple images from a sheet is cumbersome: Navigate to the sheet, wait for rendering. Find the image, add it, wait for rendering again. Repeat for every image.   As a leading BI tool, I’d expect multi-select functionality for adding images—this should be a basic feature.
Images Entity Sorting	Images entity in the library aren’t sorted by the time they were added. They appear randomly, possibly by name, and there’s no sorting option. For example, the last image I added might appear near the top instead of at the end.
Finding Images - Image Naming	Image names vary: (see diagram No. 2) Sometimes long alphanumeric codes. Sometimes titles. Sometimes short random strings (especially when added as Master Items).   Although there’s an optional field for naming images under properties, these names don’t appear in the library, making identification harder.
Tracking Image Entity Deployment	The above error message is caused by an object has been deleted in a sheet.  But what object is that? In which sheet? There is probably no way I could find out, I would like to know if there is a method to do so.   I thought to remove the entire Image entity at least get the preview working, then the next error pop up.       Now, I have to first remove all instances first where I used this images in the template.  To find this out, the only way I know is to click on each object property and then click on Image Source to compare the image long id.   So, is there a way we can see where all images are deployed in the reporting section or band or subband?
Trouble shooting – Vague Error Message	Error messages are vague and provide no clues about the root cause. For example: “Bad Request”  - what request? Patch ‘value’ – what is Patch value?  Why ‘value’ has this quotation ‘ ‘?.   I ended up recreate the whole template after deleting all my objects and this message still popping up.
Troubleshooting – Error Message without much Context	When adding a KPI as an image, I sometimes get errors despite the KPI having valid data. Could conditional visibility be the issue? Possibly—but the error messages make troubleshooting extremely difficult, especially for new users.

Hi,

I am trying to build set analysis for the sum of sales for the Max Date and Previous Date of the Max Date

I have discrete dates such as 01.01.2025, 07.07.2025, 08.07.2025, 14.11.2025 etc...

Max Date Expression (works perfectly):

Sum({<[Discrete Date]={"=[Discrete Date]='$(=Max([Discrete Date]))'"}>} Sales)

But I don't know what should I write for the previous date because there are no continuous dates. So, for example user select date from [Discrete Date] = 14.11.2025 then that is the max date while the previous available date is 08.07.2025

Thanks

Hi, Can someone please help me to share a link to download the software? Currently it says free, but takes to a page to provide my information and ask for business email. At this time, I'm not employed thus no business email. I would like to learn this product and thought it is an open source community edition. Thanks in advance.

Hello

Let me ask you a question. I'm planning to increase the column length of the source varchar (10) to varchar 100. What should I do in the Qlik Replicate task? We used a Log Stream Task before the Target Table Task.

Thanks, You

Hello,

We are trying to use Qlik Cloud Services within Qlik Application Automation. Some blocks work correctly and pass the domain in the URL as expected, but others do not. For example, we receive the following error when using the Get Space block. We are not sure if we are missing a configuration or setting. Appreciate any help. Thanks.

Did your Qlik reloads suddenly stop picking up dashboard variable values? You aren't crazy. Qlik has made significant changes to how front-end variables interact with the back-end load script, specifically regarding the behavior of standard variables vs. ScriptOnlyVariables.

The "old way" of relying on dashboard variables automatically carrying over to the script during a reload is no longer reliable due to these recent platform updates. If your ETL process depends on user input from the UI, you need a new approach.

In the video below, I break down exactly what changed and demonstrate the robust, modern solution: using Qlik Application Automation (QAA) to bridge the gap.

📅 In the video, we cover:

This is essential knowledge for any Qlik developer ensuring their data pipelines remain interactive and reliable.

Watch full video here: 
https://youtu.be/EJLoH0GZXQo

Regards,

Mark Costa

Se você usa blocos customizados no Qlik Automation, aqueles que permite executar código python, php, node.js, preste atenção na atualização do runtime que vai acontecer a partid de 31 de Janeiro de 2026.

Mais informações aqui no blog de atualização do suporte :

https://community.qlik.com/t5/Support-Updates/Update-to-the-Automations-Custom-Code-block-version-beginning/ba-p/2538957

I'm looking for a Qlik SME to serve as a help in re-developing an app someone else created. The visualizations are done, and I've piped in new data from a different source that has field names and content different that what's already there. I could use some help navigating the differences to connect the new data to the current visualizations accurately.

Hello everyone,

Currently, I'm trying to combine two datasets: one with coordinates (latitude and longitude) and one with areas (polygons) both of which I have loaded separately, and all the data can be displayed in a map. However, I need to crear an intersection between those datasets by using the operation WITHIN in Qlik Cloud so that all my points are placed inside the areas.

1. First step was to load the data accordingly.

I have 6 main areas and lots of geo points.

2. I configured the connector both of which are loaded table

3. After adding the code from the connector, the script shows this error:

Something I noticed is that there is one table, and it says my enclosing data which is the area does not contain any geometries even if the areas can be displayed on a map. Also, I tried concatenating both table and I got the same error. 

Could anyone guide me to do this, please?

Thanks a lot!