topic Re: list box with field with Expression in QlikView

list box with field with Expression

Anonymous — Thu, 15 Sep 2011 23:07:29 GMT

Hello, I am trying that a "list box" that contains 10 offices, only load 2 of them this way:

= only({<OFFICE={'NY','LA'}>} OFFICE)

but it doesn't work.

I know I can do this with a condition "if" but I want to use the fuction instead.

Have any one of you used this function ? Can you put some example of the right syntaxis for using it ?

Tks for you help.

Fri, 16 Sep 2011 07:52:47 GMT

Hello,

i'm not sure what you want. Try this:

=only({$<OFFICE*={'NY','LA'}>}OFFICE)

Function:

If you select 'NY' or 'LA' it will be displayed and it doesn't matter if any other of the 8 offices are selected.

If you select none or both of this two offices nothing will be displayed.

P.S. This functions works only in diagram.

Fri, 16 Sep 2011 08:00:45 GMT

This Expression will not work ...may be because 'Only' func returns only one Value.