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.
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!
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!
