Need help with expressions

[#1]

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

[ahaahaaha]

Hi,

May be as in attached file

Andrey

[devarasu07]

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