topic Re: Dynamic Multibox? in QlikView

Dynamic Multibox?

Wed, 18 Apr 2012 06:37:01 GMT

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

Dynamic Multibox?

Jason_Michaelides — Wed, 18 Apr 2012 06:57:25 GMT

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

Dynamic Multibox?

Wed, 18 Apr 2012 08:26:28 GMT

Hi, can you give me an example? Thanks.

Dynamic Multibox?

Jason_Michaelides — Wed, 18 Apr 2012 14:39:59 GMT

Sure. Please provide some sample data.

Jason

Re: Dynamic Multibox?

Thu, 18 Apr 2013 14:39:16 GMT

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?

Re: Dynamic Multibox?

Jason_Michaelides — Thu, 18 Apr 2013 14:53:19 GMT

Please post a sample app to demonstrate the issue.