Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Need help with expressions

Hi I am trying to create a qliksense sheet and it got a filter pane which takes value from one of the column in a dimension table.

I am trying to write an expression which only shows certain values in the filter pane from that column

For example

Column

A

B

C

D

In the filter pane I only wanted to show A and B

Which expression will be helpful to achieve this.

Thanks

2 Replies
ahaahaaha
Honored Contributor

Re: Need help with expressions

Hi,

May be as in attached file

Andrey

devarasu07
Honored Contributor II

Re: Need help with expressions

Hi,

Yeah you can try with Andrey suggestion

Calculated dimension:

"=if(Column='A' or Column='B',Column) "

Also you can you do it below way.

=pick(Match(Column,'A','B'),'A','B')

Thanks, Deva

Community Browser