https://community.qlik.com/t5/Qlik-Automate/Looping-over-a-table-to-generate-a-report/m-p/2471237#M4350 <P>Hi guys! I have the following table (please see the image attached). As seen, the first five rows have the same value (X) in the first column, and each X has a different value in the second column (a, b, c, d, e). I already used "List Values of FIeld" block to iterate over the different values in the first column (X and Y). I added the needed sheets as part of my report for every value in this List (x and y). So, x has a generated report of 5 sheets with the needed selections, y has a generated report of 5 sheets with the needed selections.&nbsp;</P> <P>The problem is the following: I need to be able to add another 6 sheets to every X, but a different selection in each of the 6 pages. So the logic of the loop would be, the first value of X should have 6 sheets with "a" as a selection on the 6 sheets, the same X should have 6 sheets with "b" as a selection on the 6 sheets and so on... The values of X and Y are already captured using the "List Values of Field" block, so how can I logically loop different selections (a,b,c,d,e)?</P> Wed, 17 Jul 2024 14:39:38 GMT samkadouh 2024-07-17T14:39:38Z https://community.qlik.com/t5/Qlik-Automate/Looping-over-a-table-to-generate-a-report/m-p/2471237#M4350 <P>Hi guys! I have the following table (please see the image attached). As seen, the first five rows have the same value (X) in the first column, and each X has a different value in the second column (a, b, c, d, e). I already used "List Values of FIeld" block to iterate over the different values in the first column (X and Y). I added the needed sheets as part of my report for every value in this List (x and y). So, x has a generated report of 5 sheets with the needed selections, y has a generated report of 5 sheets with the needed selections.&nbsp;</P> <P>The problem is the following: I need to be able to add another 6 sheets to every X, but a different selection in each of the 6 pages. So the logic of the loop would be, the first value of X should have 6 sheets with "a" as a selection on the 6 sheets, the same X should have 6 sheets with "b" as a selection on the 6 sheets and so on... The values of X and Y are already captured using the "List Values of Field" block, so how can I logically loop different selections (a,b,c,d,e)?</P> Wed, 17 Jul 2024 14:39:38 GMT https://community.qlik.com/t5/Qlik-Automate/Looping-over-a-table-to-generate-a-report/m-p/2471237#M4350 samkadouh 2024-07-17T14:39:38Z