Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)