topic Re: Automation / Set field Value not being applied correctly in Qlik Automate

Automation / Set field Value not being applied correctly

Oggy172 — Mon, 09 Jun 2025 15:48:50 GMT

Hi folks,

I have an automation that I'm sure was working ok before, but now it's not 😄

The concept is we have a lot of Van Routes that have a commission report sent to them, and so I need to create the Commission report & loop through all the routes (002, 003, 004 etc) and push the files to OneDrive, where a Power Automate script will email the pdf attachments.

So I list the field values of "Van Route" and loop through these, assigning the result to a variable $vRouteNo.

I should then filter the VanCommssion report by this value / pushh to onedrive / loop back for the next one, however I am getting unfiltered reports, in that EVERY van route is on EVERY pdf.

Any ideas?

Automation:

List values of field:

Loop

Update Variable:

Add Selection:

Re: Automation / Set field Value not being applied correctly

Anil_Babu_Samineni — Tue, 10 Jun 2025 03:49:15 GMT

let @Thomas_Hopp guide here.

Re: Automation / Set field Value not being applied correctly

marcus_sommer — Tue, 10 Jun 2025 07:43:27 GMT

Before looking for any issue with the automation make sure that the field- and variable-values have the wanted content - existing in general and having the proper values + format. Especially numbers may come now as strings respectively reverse and/or loosing leading zero's or similar stuff.

Re: Automation / Set field Value not being applied correctly

Oggy172 — Tue, 10 Jun 2025 07:48:11 GMT

Issue appears to be a limitation in a Qlik Automation where only 3 field selections can be made.

Re: Automation / Set field Value not being applied correctly

Andrew_Kruger — Wed, 25 Jun 2025 18:56:53 GMT

Based on the picture - your logic doesn't seem to be inside the loop of the dimension values? All that logic is happening after it loops through the field values?

Re: Automation / Set field Value not being applied correctly

Andrew_Kruger — Wed, 25 Jun 2025 19:02:39 GMT

You may also wish to consider a Tabular | PixelPerfect | HTML report using the cycle feature --- https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/reports-cycles.htm.