How do you filter out unwanted data after selecting the dimension?

[#1]

Hi all,

I have a rather simple question which I would like to know the best way of doing it.

Let's say I want to create a multibox for a selection purpose. The dimension selected contains the below data.

How do I only want 2012 to 2013 data to appear in the multibox? Right not it shows everything for selection.

Thx!

INTAKE

JAN2010

JUL2010

JAN2011

JUL2011

JAN2012

JUL2012

JAN2013

JUL2013

JAN2014

JUL2014

JAN2015

JUL2015

[tresesco · Accepted solution]

You can create an expression instead of taking the field directly in the multibox. And put the expression accordingly, like:

If(Right(INTAKE,4)='2012' or Right(INTAKE,4)='2013' , INTAKE)

[#3]

Hi,

You can also try this  in the expression dialog box

=if(WildMatch(INTAKE,'*2012','*2013'),INTAKE).

PFA,

Thanks and Regards,

S.Amuthabharathi

[er_mohit]

Try this

=pick(Match(INTAKE,'*2012','*2013'),'2012','2013') .

[#5]

Hi,

Instead of using the dimension directly, you can create an expression & use it in the multibox. The expression can be :

=IF(Right (INTAKE,4) = '2012', INTAKE,

IF (Right (INTAKE,4) = '2013', INTAKE))

This is just one way to write the expression, there can be many other ways to write the expression to achieve the result you want. The key is, just write an expression instead of using the dimesnion column directly.

Hope this helps!