I have 5 fields from Payroll data - Employee ID, Social Security Number, Name, Start Date, Position.
I want to list them in a table, but I want the Qlik User to be able to select a filter and inn the table, display either the Employee ID OR the SSN based on the filter selected.
I think you should be able to create a filter using dollar sign expansion of an IsLand table to do this. I would read about The Magic of Dollar Expansions before I go about this.
I think you should be able to create a filter using dollar sign expansion of an IsLand table to do this. I would read about The Magic of Dollar Expansions before I go about this.
