Automation / Set field Value not being applied correctly

[Oggy172]

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:

[Anil_Babu_Samineni]

let @Thomas_Hopp guide here.

[marcus_sommer]

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.

[Oggy172]

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

[Andrew_Kruger]

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?

[Andrew_Kruger]

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