Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

gerardo_ornelas
New Contributor II

list box with field with Expression

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.

2 Replies
Not applicable

Re: list box with field with Expression

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.

Not applicable

list box with field with Expression

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

Community Browser