Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jay_shahi90
New Contributor

Only showing certain values in Filter Pane

Hi.

I am trying to show only exclusive values within the dimension in a filter pane
Whats the best way to do that?

1 Solution

Accepted Solutions
consultant_bi
Contributor

Re: Only showing certain values in Filter Pane

the best solution is if and wild match combined

Sans titre.png

for example we want to display just the values that contains sony and toshiba so use this in expression formula :

=if(wildmatch(PRODNAME,'*Sony*'),PRODNAME,

if(wildmatch(PRODNAME,'*Toshiba*'),PRODNAME))

now the result is :

Sans titre2.png

5 Replies
devarasu07
Honored Contributor II

Re: Only showing certain values in Filter Pane

Hi,

you can try like this, (create a list box and add calculated dimension like below

if(Match(fieldname,'value'),'result-value')

example, Product dimension,

if(match(Product,'A','B'),'A','B')

or

if(WildMatch(Product,'A*','B*'),'A','B')

Thanks,Deva

consultant_bi
Contributor

Re: Only showing certain values in Filter Pane

the best solution is if and wild match combined

Sans titre.png

for example we want to display just the values that contains sony and toshiba so use this in expression formula :

=if(wildmatch(PRODNAME,'*Sony*'),PRODNAME,

if(wildmatch(PRODNAME,'*Toshiba*'),PRODNAME))

now the result is :

Sans titre2.png

jay_shahi90
New Contributor

Re: Only showing certain values in Filter Pane

Thank you so much. It worked!

jay_shahi90
New Contributor

Re: Only showing certain values in Filter Pane

Thank you sir. This worked as well!

devarasu07
Honored Contributor II

Re: Only showing certain values in Filter Pane

Hi,

Help to close this thread by marking as helpful and correct.thanks

Qlik Community Tip: Marking Replies as Correct or Helpful