Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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

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)