topic Comparing installation items saying which level is the last installed in QlikView https://community.qlik.com/t5/QlikView/Comparing-installation-items-saying-which-level-is-the-last/m-p/495233#M691324 <HTML><HEAD></HEAD><BODY><P>Hey guys, so, i have an table like this:</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="568"><TBODY><TR><TD class="xl114" height="20" width="64">A/C</TD><TD class="xl114" style="border-left: none;" width="64">Instalacao</TD><TD class="xl114" style="border-left: none;" width="78"> </TD><TD class="xl114" style="border-left: none;" width="255">DESCR_INST</TD><TD class="xl114" style="border-left: none;" width="107">Installed? (Y/N)</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">a</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">b</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">c</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">d</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">e</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">f</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">g</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">h</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">kkkk</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">j</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">k</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">l</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">m</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">n</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">o</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">p</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">q</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">r</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">3</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">s</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">3</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">t</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">4</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">u</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">4</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">v</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">5</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">x</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">5</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">y</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">5</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">z</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">w</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">aa</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">bb</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">cc</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">dd</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">ee</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">ff</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR></TBODY></TABLE><P></P><P></P><P>I want to show in a table all the parts that were not installed, but i don't want it to show everything after the last 'Yes'. How do I do that?</P></BODY></HTML> Mon, 30 Sep 2013 14:00:20 GMT 2013-09-30T14:00:20Z Comparing installation items saying which level is the last installed https://community.qlik.com/t5/QlikView/Comparing-installation-items-saying-which-level-is-the-last/m-p/495233#M691324 <HTML><HEAD></HEAD><BODY><P>Hey guys, so, i have an table like this:</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="568"><TBODY><TR><TD class="xl114" height="20" width="64">A/C</TD><TD class="xl114" style="border-left: none;" width="64">Instalacao</TD><TD class="xl114" style="border-left: none;" width="78"> </TD><TD class="xl114" style="border-left: none;" width="255">DESCR_INST</TD><TD class="xl114" style="border-left: none;" width="107">Installed? (Y/N)</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">a</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">b</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">c</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">d</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">e</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">f</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">g</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">h</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">1</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">kkkk</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">j</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">k</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">l</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">m</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">n</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">o</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">p</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">q</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">2</TD><TD class="xl113" style="border-top: none; border-left: none;"> </TD><TD class="xl112" style="border-top: none; border-left: none;">r</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">3</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">s</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">3</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">t</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">4</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">u</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">4</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">v</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">5</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">x</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">5</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">y</TD><TD class="xl113" style="border-top: none; border-left: none;">Yes</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">5</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">z</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">w</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">aa</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">bb</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">cc</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">dd</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">ee</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR><TR><TD align="right" class="xl113" height="20" style="border-top: none;">4</TD><TD align="right" class="xl113" style="border-top: none; border-left: none;">6</TD><TD class="xl115" style="border-top: none; border-left: none;" width="78"> </TD><TD class="xl112" style="border-top: none; border-left: none;">ff</TD><TD class="xl113" style="border-top: none; border-left: none;">No</TD></TR></TBODY></TABLE><P></P><P></P><P>I want to show in a table all the parts that were not installed, but i don't want it to show everything after the last 'Yes'. How do I do that?</P></BODY></HTML> Mon, 30 Sep 2013 14:00:20 GMT https://community.qlik.com/t5/QlikView/Comparing-installation-items-saying-which-level-is-the-last/m-p/495233#M691324 2013-09-30T14:00:20Z