Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Poppel
Contributor II
Contributor II

Only show certain fields instead of all fields by using Variable Input extension Qlik Sense

Hi,

I have a sheet with 'Area', 'Income', 'Gender' as fields.

I made a customised variable named vDim1 (Expression: =[$Field])

And then I used the Variable Input extension to create buttons to show the name of fields (Expression =concat(distinct[$Field],'|')

However, I want to get rid of the button for 'Area'  and only show the buttons of 'Income', and 'Gender'. But I don't know how to do that. I'm guessing I need to change something in the expression for vDim1. Hard coding is fine by me since there are only a three fields in total.

Can anyone please give some help on this?

Cheers,

Poppel

1 Solution

Accepted Solutions
Poppel
Contributor II
Contributor II
Author

In the end I put

'Gender~Gender|Income~Income'

instead of  

=concat(distinct[$Field],'|')

 

It is hardcoding but it would do for the job.

 

 

View solution in original post

1 Reply
Poppel
Contributor II
Contributor II
Author

In the end I put

'Gender~Gender|Income~Income'

instead of  

=concat(distinct[$Field],'|')

 

It is hardcoding but it would do for the job.