Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
BigKev
Contributor
Contributor

Only shows columns information based on filter selection

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

0 Replies