Only shows columns information based on filter selection

[BigKev]

Hi All,

So below is my data structure.

Field Name	Source Table Name	Data Type	Char Length	Business Glossary Terms	Description
First Name	Clients Details	Char	100	Client First Name	The First name of the Insurance Holder
Last Name	Clients Details	Char	100	Client Last Name	The Last name of the Insurance Holder
Client ID	Clients Details	Num	20	Client Number	Insurance Holder number
Monthly Payment	Payment	Num	50	Client Sum Payment	Insurance Monthly Payment Fee

I want to show the data on straight table in Qlik sense but with ability to filter what to show from the columns:

• If ‘All’ is selected, then the Table will show all columns information
• If ‘Business Glossary’ is selected, then the Table will show “Field Name”, “Business Glossary Terms”,and “Description” column information
• If ‘Data Glossary’ is selected, then the Table will show “Field Name”, “Source Table Name”, “Data Type”, and “Char Length” column information

Does anyone know how I can achieve this in Qlik Sense?

Cheers,

Big Kev