Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I am trying to show only exclusive values within the dimension in a filter pane
Whats the best way to do that?
the best solution is if and wild match combined
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 :
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
the best solution is if and wild match combined
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 :
Thank you so much. It worked!
Thank you sir. This worked as well!
Hi,
Help to close this thread by marking as helpful and correct.thanks