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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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)