topic How to hide the values in list box ?? in QlikView

How to hide the values in list box ??

Fri, 11 Feb 2011 12:05:31 GMT

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

How to hide the values in list box ??

matt_crowther — Fri, 11 Feb 2011 12:17:53 GMT

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

How to hide the values in list box ??

Fri, 11 Feb 2011 12:35:32 GMT

Excellent !!

That's working fine matt..

Thanks

How to hide the values in list box ??

Mon, 07 Mar 2011 13:07:56 GMT

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?

How to hide the values in list box ??

Miguel_Angel_Baeyens — Mon, 07 Mar 2011 13:12:06 GMT

Hello Nick,

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

Hope that helps.

How to hide the values in list box ??

Mon, 07 Mar 2011 13:20:57 GMT

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.

How to hide the values in list box ??

Miguel_Angel_Baeyens — Mon, 07 Mar 2011 13:39:17 GMT

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.

How to hide the values in list box ??

Tue, 08 Mar 2011 02:08:58 GMT

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 !

Re: How to hide the values in list box ??

Fri, 07 Sep 2012 18:17:41 GMT

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