topic Re: Show/hide a field in multibox in QlikView

Show/hide a field in multibox

vlad_komarov — Wed, 21 Nov 2012 17:24:29 GMT

Hello,

Just checking if anybody knows the way to show/hide a field in Multibox (similar to "Conditional" option in chart's expression, for example).

Any suggestions will be appreciated.

Best regards,

Vladimir

Re: Show/hide a field in multibox

MayilVahanan — Wed, 21 Nov 2012 17:29:19 GMT

There is no option like that in multi box upto my knowledge..

Re: Show/hide a field in multibox

Gysbert_Wassenaar — Wed, 21 Nov 2012 17:39:04 GMT

No, not really. You can use a variable to use in an expression in the multibox. If the variable contains a field name then this is shown in the multibox, if the variable is empty there will still be a selection 'row' in the multibox, but there's nothing to select. You could do it with a macro by simply removing and adding the fields or expressions using the RemoveField and AddField methods of the multibox control.

Re: Show/hide a field in multibox

Anonymous — Wed, 21 Nov 2012 17:55:26 GMT

If use variables, create two multiboxes, and show conditionaly one or another depending on variable.

Regards,

Michael

Re: Show/hide a field in multibox

vlad_komarov — Wed, 21 Nov 2012 19:33:20 GMT

It would be the easiest question to answer if it would be one. Thanks, but I was looking for non-trivial solution.

Re: Show/hide a field in multibox

vlad_komarov — Wed, 21 Nov 2012 19:34:22 GMT

Thanks, I will try that.

Regards,

Vladimir

Re: Show/hide a field in multibox

vlad_komarov — Wed, 21 Nov 2012 19:43:17 GMT

Michael,

Unfortunatelly your suggestion will not work in my case (I wish if it could be that simple). I have to use multibox with (potentially) up to 200 fields to select. The combination of the fields to display might be flexible.

So, I was looking for other solution(s). It looks like the macro is the only choice.

Regards,

Vladimir

Re: Show/hide a field in multibox

MayilVahanan — Wed, 21 Nov 2012 19:44:42 GMT

I thought, you want just confirmation about that option..so i just told the information.

PFA

Re: Show/hide a field in multibox

vlad_komarov — Wed, 21 Nov 2012 20:00:52 GMT

Thanks, your example is close to the idea I've tried first, but I need to hide the whole row when the data is not avaialble (selected in your case) and not the "Fields Displayed" part only.

Regards,

Vladimir

Re: Show/hide a field in multibox

Anonymous — Tue, 08 Apr 2014 05:47:52 GMT

PFA,

In THis way you can enable disable a field in Multibox

Re: Show/hide a field in multibox

vlad_komarov — Tue, 08 Apr 2014 17:49:24 GMT

Nitin,

Great idea!

Thank you for your solution.

It works exactly as I needed.

Regards,

Vladimir

Re: Show/hide a field in multibox

markmccoid — Wed, 18 Mar 2015 15:22:00 GMT

So, I'm looking at this multibox and I see one Field in the "Fields Displayed" area:

=$(=SubField(concat(distinct [$Field], '|'), '|', 1))

But I have no idea how this actually works. When I copy the Multibox, the copy doesn't work, but the original one does.

This feature is really cool, but I can't figure out what is going on. Can anyone enlighten me?

Thanks!

Re: Show/hide a field in multibox

Anonymous — Wed, 18 Mar 2015 16:12:55 GMT

Because it is not one multi box but a set of many multi boxes, where only the top one has caption. Press Ctrl+Shift+S to see what's going on . See that the expression and the show condition is slightly different for each.

Re: Show/hide a field in multibox

markmccoid — Wed, 18 Mar 2015 16:15:19 GMT

Thanks! It makes much more sense now!

Re: Show/hide a field in multibox

Wed, 03 Feb 2016 09:35:48 GMT

Thanks, but I can't understand how to create the $Field.

I have this kind of scenario:

multiBox with:

dim1

dim2

dim3

then I have a table which has:

dim, inUse, labelName

dim1, 1, DATE

dim2, 1, GENDER

dim3, 0, NULL

In my multiBox I want to show for this only dim1 and dim2 with their labels, how can I do it?

Thanks,