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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.