Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Poppel
New 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
New Contributor II

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

In the end I put

'Gender~Gender|Income~Income'

instead of  

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

 

It is hardcoding but it would do for the job.

 

 

1 Reply
Poppel
New Contributor II

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

In the end I put

'Gender~Gender|Income~Income'

instead of  

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

 

It is hardcoding but it would do for the job.