How to hide the values in list box ??

[#1]

I have a YEAR dimension like this :

Year ( Booking_Date) as Year

Field Values are 2006,2007,2008,2009,2010.

When I add this list box to the sheet, if I want to see only 2010 in list box …how I can do this ??

Many thanks

[matt_crowther · Accepted solution]

Set the ListBox value to '<Expression>' - it's either at the top or bottom of the dimensions list. Enter the expression:

=if(Year='2010',Year)

That works for me.

Hope that helps,

Matt - Visual Analytics Ltd

[#3]

Excellent !!

That's working fine matt..

Thanks

[#4]

Hi Matt,

This feature is in V10 right?

I don't see the "expression" in V9 SR6.

Does it mean in V10. I can choose what value to display in the list box now?

[Miguel_Angel_Baeyens]

Hello Nick,

"<Expression>" does appear in Listboxes in Version 9. Once you click on it, the expression dialog opens.

Hope that helps.

[#6]

Hi Miguel,

I right-click on the list box, then it's the Properties,

i just looked at the v10 what's new doc, it says, expression is the new listbox feature in v10.

How do you go to expression in v9 sr6? could you provide some steps?

thanks.

[Miguel_Angel_Baeyens]

Hello Nick,

I'm afraid we're talking about different things. In Version 9 (as in Version 10), go to the sheet background, right click on an empty space, New Sheet Object, Listbox. In the General tab you have the "Field" dropdown. Expand, and you will see, (usually at the top of the list of available fields in V9) the word "<Expression>". Click on that and the Expression dialog will appear.

There you can write the code posted above.

Hope that helps.

[#8]

Hi Miguel,

Thanks i found it !!!! and this is what i have been looking for...

I thought it'd appear like a button to click or a tab.

Thanks !

[#9]

Thanks!!!!! I needed this one big time!