https://community.qlik.com/t5/Qlik-Automate/Iterative-Reporting-using-Field-List/m-p/2514463#M5771 <P>What I thought would be quite simple seems unintuitive - I'm making reports for stores, and I'd like to create a report for each store, and generate sheets for each day.&nbsp;</P><P>Seems quite simple, however the generated report seems to show the last selection applied from the inner-loop to the whole report ( I.E. All sheets are filtered for 'Sunday' , rather than the front sheet having all days, then 7 sheets for each day of the week )</P><P>Is there a way to 'lock' the sheets when they're created, or another way to iterate through fields?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="110_0-1744729345045.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/179654i0ED234B6B6B35B01/image-size/large?v=v2&amp;px=999" role="button" title="110_0-1744729345045.png" alt="110_0-1744729345045.png" /></span></P><P>&nbsp;</P> Tue, 15 Apr 2025 15:03:14 GMT 110 2025-04-15T15:03:14Z https://community.qlik.com/t5/Qlik-Automate/Iterative-Reporting-using-Field-List/m-p/2514463#M5771 <P>What I thought would be quite simple seems unintuitive - I'm making reports for stores, and I'd like to create a report for each store, and generate sheets for each day.&nbsp;</P><P>Seems quite simple, however the generated report seems to show the last selection applied from the inner-loop to the whole report ( I.E. All sheets are filtered for 'Sunday' , rather than the front sheet having all days, then 7 sheets for each day of the week )</P><P>Is there a way to 'lock' the sheets when they're created, or another way to iterate through fields?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="110_0-1744729345045.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/179654i0ED234B6B6B35B01/image-size/large?v=v2&amp;px=999" role="button" title="110_0-1744729345045.png" alt="110_0-1744729345045.png" /></span></P><P>&nbsp;</P> Tue, 15 Apr 2025 15:03:14 GMT https://community.qlik.com/t5/Qlik-Automate/Iterative-Reporting-using-Field-List/m-p/2514463#M5771 110 2025-04-15T15:03:14Z https://community.qlik.com/t5/Qlik-Automate/Iterative-Reporting-using-Field-List/m-p/2514546#M5776 <P>So the solution after all is using the 'add selection to sheet' node .&nbsp;</P><P>&nbsp;</P><P>It'd still be great to use a more consolidated set of nodes, with inheritance, I.E. - if I pick the app on node 1, node 2/3 can use the reference above them in the chain , rather than having to create a new appID reference.</P><P>&nbsp;</P> Wed, 16 Apr 2025 06:57:36 GMT https://community.qlik.com/t5/Qlik-Automate/Iterative-Reporting-using-Field-List/m-p/2514546#M5776 110 2025-04-16T06:57:36Z