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: 
samkadouh
Contributor II
Contributor II

Looping over a table to generate a report

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. 

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)?

Labels (1)
0 Replies