Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
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
Highlighted
ahaahaaha
Honored Contributor

Re: Need help with expressions

Hi,

May be as in attached file

Andrey

Highlighted
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