Inconsisent behaviour with loops

artav — Tue, 03 Feb 2026 14:08:55 GMT

Hello,

I have created an app to monitor management indicators in Qlik. Next to that, I created an automation to generate reports based on it.

My company has departments and agencies. I have special graphs for both of these, in dedicated sheets (which are templates for the app) named "Slide department {number}" and "Slide agency {number}". For each of these I have created two loops that:

Filter sheets which contain "department"/"agency" in their name
List the values if the "department"/"agency" field
Filter the unwanted values
Add the sheet to the report (based on its id)
Add to the sheet a selection (either the department or the agency)

The loop for the departments work fine. For each department, I get the two sheets with correct filtering. However, for the agencies (they are 2), the first one works well (the 4 sheets are in the report and with filtering), but in my history and on my report, I see that for the other agency, instead of selecting the good ids of the sheets, for the 4 sheets the selected id is the one of one of my department sheets. So I get 4 times the same sheet, and the one I wanted.

Do you have an explanation as to why this is happening? I can potentially provide some data, but it would be in French.

Re: Inconsisent behaviour with loops

artav — Wed, 04 Feb 2026 09:24:55 GMT

It seems that I manage to find a solution. In my loop for agencies, I had to filter among some sheets on a parameter, so I did with a "Filter list" module. But it seemed that this was the source of trouble. I replaced it with a condition, and everything is fine now!

topic Re: Inconsisent behaviour with loops in Qlik Automate

Inconsisent behaviour with loops

Re: Inconsisent behaviour with loops