Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (1)
1 Solution

Accepted Solutions
jason_michaelid
Honored Contributor II

Dynamic Multibox?

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

5 Replies
jason_michaelid
Honored Contributor II

Dynamic Multibox?

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

Dynamic Multibox?

Hi, can you give me an example? Thanks.

jason_michaelid
Honored Contributor II

Dynamic Multibox?

Sure.  Please provide some sample data.

Jason

Not applicable

Re: Dynamic Multibox?

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_michaelid
Honored Contributor II

Re: Dynamic Multibox?

Please post a sample app to demonstrate the issue.

Community Browser