Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
110
Creator
Creator

Iterative Reporting using Field List?

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. 

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 )

Is there a way to 'lock' the sheets when they're created, or another way to iterate through fields?

110_0-1744729345045.png

 

Labels (1)
1 Solution

Accepted Solutions
110
Creator
Creator
Author

So the solution after all is using the 'add selection to sheet' node . 

 

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.

 

View solution in original post

1 Reply
110
Creator
Creator
Author

So the solution after all is using the 'add selection to sheet' node . 

 

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.