topic Re: Remove Values from System Tables in App Development https://community.qlik.com/t5/App-Development/Remove-Values-from-System-Tables/m-p/1298596#M27537 <HTML><HEAD></HEAD><BODY><P>So you want a list box which only shows Customer in it? May be this</P><P><STRONG>If($Table = 'Customer', $Table)</STRONG></P><P></P><P>or if you have 10 tables and you want 3 of them:</P><P><STRONG>If(Match($Table, 'Table1', 'Table2', 'Table3'), $Table)</STRONG></P></BODY></HTML> Tue, 11 Apr 2017 14:24:39 GMT sunny_talwar 2017-04-11T14:24:39Z Remove Values from System Tables https://community.qlik.com/t5/App-Development/Remove-Values-from-System-Tables/m-p/1298595#M27536 <HTML><HEAD></HEAD><BODY><P>I'm using the System fields($Table,$Field) to get a list of values for each column that the user can filter on. I'd like to filter the values that display when using these fields.</P><P></P><P>For Example:</P><P>If I had two tables loaded into the qlik app (Customer,Employee) could I filter the values form $Table to only show customer?</P><P></P><P></P><P>Thanks,</P><P>Mike</P></BODY></HTML> Tue, 11 Apr 2017 14:15:41 GMT https://community.qlik.com/t5/App-Development/Remove-Values-from-System-Tables/m-p/1298595#M27536 2017-04-11T14:15:41Z Re: Remove Values from System Tables https://community.qlik.com/t5/App-Development/Remove-Values-from-System-Tables/m-p/1298596#M27537 <HTML><HEAD></HEAD><BODY><P>So you want a list box which only shows Customer in it? May be this</P><P><STRONG>If($Table = 'Customer', $Table)</STRONG></P><P></P><P>or if you have 10 tables and you want 3 of them:</P><P><STRONG>If(Match($Table, 'Table1', 'Table2', 'Table3'), $Table)</STRONG></P></BODY></HTML> Tue, 11 Apr 2017 14:24:39 GMT https://community.qlik.com/t5/App-Development/Remove-Values-from-System-Tables/m-p/1298596#M27537 sunny_talwar 2017-04-11T14:24:39Z