Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Multibox?

Hi,

I have questions...

Is it possible to make the multi-box dynamic? I mean, when I select class in the listbox - the field names of the multibox will be change... see example below...

CLASS LISTBOX

GROCERY

APPLIANCE

KITCHEN

MULTIBOX

when I select GROCERY

     the fields in the multi box should be

               ITEM, PRICE

when I select APPLIANCE

     the fields in the multi box should be

               APPLIANCE NAME, BRAND

when I select KITCHEN

     the fields in the multi box should be

               MENU, TASTE


Thanks and Best Regards,

Bill

1 Solution

Accepted Solutions
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Sure. Just add a bunch of expressions as the milti-box dimensions like:

If(Class='Grocery',ITEM,

  If(Class='Appliance',Name,

     If(Class='Kitchen',Menu

)))

If there are many more possibilities I would look at putting an Inline table in the script that matches the values to multi-box requirements, then having a more simple expression here.

Hope this helps,

Jason

View solution in original post

5 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Sure. Just add a bunch of expressions as the milti-box dimensions like:

If(Class='Grocery',ITEM,

  If(Class='Appliance',Name,

     If(Class='Kitchen',Menu

)))

If there are many more possibilities I would look at putting an Inline table in the script that matches the values to multi-box requirements, then having a more simple expression here.

Hope this helps,

Jason

Not applicable
Author

Hi, can you give me an example? Thanks.

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Sure.  Please provide some sample data.

Jason

Not applicable
Author

I have a similar need. It works fine to display the items, however, I cannot select any values when a multibox field is an expression. It shows me the possible values but when I click on it, nothing is actually selected. If, instead of the expression, I add each one of the fields as separate fields It works but I can only show one or the other depending on my if check.

Any idea?

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Please post a sample app to demonstrate the issue.