Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove Values from System Tables

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.

For Example:

If I had two tables loaded into the qlik app (Customer,Employee) could I filter the values form $Table to only show customer?

Thanks,

Mike

1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

So you want a list box which only shows Customer in it? May be this

If($Table = 'Customer', $Table)

or if you have 10 tables and you want 3 of them:

If(Match($Table, 'Table1', 'Table2', 'Table3'), $Table)

View solution in original post

1 Reply
sunny_talwar
MVP
MVP

So you want a list box which only shows Customer in it? May be this

If($Table = 'Customer', $Table)

or if you have 10 tables and you want 3 of them:

If(Match($Table, 'Table1', 'Table2', 'Table3'), $Table)