topic Show Excluded in App Development

topic Show Excluded in App Development https://community.qlik.com/t5/App-Development/Show-Excluded/m-p/37065#M2525 <HTML><HEAD></HEAD><BODY><P>Hi Qlikers,</P><P></P><P>I would like to display in a table the list of excluded values. Data looks like this:</P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="365"><TBODY><TR><TD class="xl63" height="19" width="101">Extract_Date</TD><TD class="xl63" style="border-left: none;" width="88">Project</TD><TD class="xl63" style="border-left: none;" width="88">Cat</TD><TD class="xl63" style="border-left: none;" width="88">Info</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">15/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">A1</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">16/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">A2</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">17/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">A3</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">18/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">A4</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">19/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">A5</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">20/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">A6</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">21/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A7</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">22/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A8</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">23/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A9</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">24/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A10</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">25/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A11</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">26/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A12</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">27/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A13</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">28/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A14</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">29/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A15</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">30/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A16</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">15/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B1</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">16/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B2</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">17/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B3</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">18/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B4</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">19/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B5</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">20/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B6</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">21/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B7</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">22/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B8</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">23/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B9</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">24/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B10</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">25/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B11</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">26/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B12</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">27/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B13</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">28/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B14</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">29/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B15</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">30/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B16</TD></TR></TBODY></TABLE><P></P><P></P><P>If I filter on Project = A, Cat=1 I get this:</P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="365"><TBODY><TR><TD class="xl65" height="19" width="101">Extract_Date</TD><TD class="xl65" style="border-left: none;" width="88">Project</TD><TD class="xl65" style="border-left: none;" width="88">Cat</TD><TD class="xl65" style="border-left: none;" width="88">Info</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">15/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">A1</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">16/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">A2</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">17/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">A3</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">18/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">A4</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">19/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">A5</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">20/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;"><P>A6</P></TD></TR></TBODY></TABLE><P></P><P>But what I would like to display is what is excluded:</P><P></P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="365"><TBODY><TR><TD class="xl66" height="19" width="101">21/04/2018</TD><TD class="xl65" style="border-left: none;" width="88">A</TD><TD class="xl65" style="border-left: none;" width="88">2</TD><TD class="xl65" style="border-left: none;" width="88">A7</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">22/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A8</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">23/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A9</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">24/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A10</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">25/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A11</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">26/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A12</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">27/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A13</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">28/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A14</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">29/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A15</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">30/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A16</TD></TR></TBODY></TABLE><P></P><P>  </P><P>How do I get this ? </P><P></P><P>Thanks for your help</P></BODY></HTML> Sun, 15 Apr 2018 15:38:55 GMT reivax31 2018-04-15T15:38:55Z Show Excluded https://community.qlik.com/t5/App-Development/Show-Excluded/m-p/37065#M2525 <HTML><HEAD></HEAD><BODY><P>Hi Qlikers,</P><P></P><P>I would like to display in a table the list of excluded values. Data looks like this:</P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="365"><TBODY><TR><TD class="xl63" height="19" width="101">Extract_Date</TD><TD class="xl63" style="border-left: none;" width="88">Project</TD><TD class="xl63" style="border-left: none;" width="88">Cat</TD><TD class="xl63" style="border-left: none;" width="88">Info</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">15/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">A1</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">16/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">A2</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">17/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">A3</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">18/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">A4</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">19/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">A5</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">20/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">A6</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">21/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A7</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">22/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A8</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">23/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A9</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">24/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A10</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">25/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A11</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">26/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A12</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">27/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A13</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">28/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A14</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">29/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A15</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">30/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD class="xl63" style="border-top: none; border-left: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">A16</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">15/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B1</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">16/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B2</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">17/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B3</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">18/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B4</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">19/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B5</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">20/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B6</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">21/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B7</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">22/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B8</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">23/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B9</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">24/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B10</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">25/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B11</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">26/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B12</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">27/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B13</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">28/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B14</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">29/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B15</TD></TR><TR><TD class="xl64" height="19" style="border-top: none;">30/04/2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD class="xl63" style="border-top: none; border-left: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">B16</TD></TR></TBODY></TABLE><P></P><P></P><P>If I filter on Project = A, Cat=1 I get this:</P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="365"><TBODY><TR><TD class="xl65" height="19" width="101">Extract_Date</TD><TD class="xl65" style="border-left: none;" width="88">Project</TD><TD class="xl65" style="border-left: none;" width="88">Cat</TD><TD class="xl65" style="border-left: none;" width="88">Info</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">15/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">A1</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">16/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">A2</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">17/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">A3</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">18/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">A4</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">19/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">A5</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">20/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;"><P>A6</P></TD></TR></TBODY></TABLE><P></P><P>But what I would like to display is what is excluded:</P><P></P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="365"><TBODY><TR><TD class="xl66" height="19" width="101">21/04/2018</TD><TD class="xl65" style="border-left: none;" width="88">A</TD><TD class="xl65" style="border-left: none;" width="88">2</TD><TD class="xl65" style="border-left: none;" width="88">A7</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">22/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A8</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">23/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A9</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">24/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A10</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">25/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A11</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">26/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A12</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">27/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A13</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">28/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A14</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">29/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A15</TD></TR><TR><TD class="xl66" height="19" style="border-top: none;">30/04/2018</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">A16</TD></TR></TBODY></TABLE><P></P><P>  </P><P>How do I get this ? </P><P></P><P>Thanks for your help</P></BODY></HTML> Sun, 15 Apr 2018 15:38:55 GMT https://community.qlik.com/t5/App-Development/Show-Excluded/m-p/37065#M2525 reivax31 2018-04-15T15:38:55Z Re: Show Excluded https://community.qlik.com/t5/App-Development/Show-Excluded/m-p/37066#M2526 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Sample attached</P></BODY></HTML> Sun, 15 Apr 2018 15:58:15 GMT https://community.qlik.com/t5/App-Development/Show-Excluded/m-p/37066#M2526 Chanty4u 2018-04-15T15:58:15Z Re: Show Excluded https://community.qlik.com/t5/App-Development/Show-Excluded/m-p/37067#M2527 <HTML><HEAD></HEAD><BODY><P>Try Using Select Excluded Trigger on Field</P></BODY></HTML> Sun, 15 Apr 2018 16:47:05 GMT https://community.qlik.com/t5/App-Development/Show-Excluded/m-p/37067#M2527 passionate 2018-04-15T16:47:05Z Re: Show Excluded https://community.qlik.com/t5/App-Development/Show-Excluded/m-p/37068#M2528 <HTML><HEAD></HEAD><BODY><P>Hi, sorry for the delay. I'm a Qlik Sense user and only manage .qvf </P><P></P><P>Could you send the expression or a qvf format?</P><P></P><P>Thanks for your support</P></BODY></HTML> Wed, 18 Apr 2018 07:19:06 GMT https://community.qlik.com/t5/App-Development/Show-Excluded/m-p/37068#M2528 reivax31 2018-04-18T07:19:06Z