topic Loop and Lock and Reduce Task in QlikView https://community.qlik.com/t5/QlikView/Loop-and-Lock-and-Reduce-Task/m-p/238888#M1332565 <HTML><HEAD></HEAD><BODY><P></P><DIV><P>I hope I understand this correctly. Here's my idea based on the description.</P><P>Add two tables that both link to a student ID field on the student dimension table, not the fact table. One is whether the student ever had Title I status. The other is all the schools that a student ever attended.</P><P>Now when you choose your school and a Title I status of TRUE, you will see all students that ever had title I status that ever went to your school.</P><P>There are a couple modifications I can imagine depending on the specific question to be answered.</P></DIV><BR /><BR /></BODY></HTML> Wed, 29 Apr 2009 04:06:38 GMT 2009-04-29T04:06:38Z Loop and Lock and Reduce Task https://community.qlik.com/t5/QlikView/Loop-and-Lock-and-Reduce-Task/m-p/238887#M1332562 <HTML><HEAD></HEAD><BODY><P>I have a need to have publisher loop through 2 field values to find a group of students. Once that group of students is found, I need it to select those values, then drop the other two values.</P><P>For example, I want to find all my Title I kids in My school at any time and see their progression into the next grades.</P><P>If I select all Title I kids and my school, the reduction task will only show me my title I kids. Those kids were not always at my school, nor did they have a title I status. I want to see how they progressed after they left the Title I program to determine the efficiency of my program.</P><P>Any help is appreciated.</P><P>Larry [:|]<BR />Colorado</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Loop-and-Lock-and-Reduce-Task/m-p/238887#M1332562 2026-01-26T18:19:17Z Loop and Lock and Reduce Task https://community.qlik.com/t5/QlikView/Loop-and-Lock-and-Reduce-Task/m-p/238888#M1332565 <HTML><HEAD></HEAD><BODY><P></P><DIV><P>I hope I understand this correctly. Here's my idea based on the description.</P><P>Add two tables that both link to a student ID field on the student dimension table, not the fact table. One is whether the student ever had Title I status. The other is all the schools that a student ever attended.</P><P>Now when you choose your school and a Title I status of TRUE, you will see all students that ever had title I status that ever went to your school.</P><P>There are a couple modifications I can imagine depending on the specific question to be answered.</P></DIV><BR /><BR /></BODY></HTML> Wed, 29 Apr 2009 04:06:38 GMT https://community.qlik.com/t5/QlikView/Loop-and-Lock-and-Reduce-Task/m-p/238888#M1332565 2009-04-29T04:06:38Z