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