topic Re: Do not show default selection in current selection Box in QlikView

Do not show default selection in current selection Box

didierodayo — Fri, 21 Oct 2016 00:37:08 GMT

Hello,

I have a select in field action trigger applied to a Qlikview document. It is working fine when the document is opened.

question: is it possible not to show that selection in the CUrrent Selection Box? how can I achieve this?

thanks

Didier

Re: Do not show default selection in current selection Box

rwunderlich — Fri, 21 Oct 2016 01:19:39 GMT

You can suppress a field from appearing in the Current Selections box by marking it as a hidden field in the script. You can do this one of two ways:

SET HidePrefix='_';

That will hide any fieldname that begins with _ ("eg _Currency")

TAG FIELD myField with '$hidden';

That will make "myField" a hidden field.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Do not show default selection in current selection Box

didierodayo — Fri, 21 Oct 2016 01:31:29 GMT

HI Rob,

the challenge with this is that I have the field as a list box which is available to users. when they select from the filter (list box) I want it to show in the current selection box BUT when the document first loads my default selection is not show (of course it will be highlighted in the list box).

it that possible or would I load the field twice 1 hidden and 1 available?

Re: Do not show default selection in current selection Box

rwunderlich — Fri, 21 Oct 2016 01:36:23 GMT

I was afraid that's what you were going to come back with

I think your idea of loading the field twice and selecting the hidden field in your trigger would be a good solution. Unfortunately, the non-hidden field will not show as green in the listbox. But it will show as white, and the other values gray. Hope that's acceptable.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Do not show default selection in current selection Box

didierodayo — Fri, 21 Oct 2016 01:38:38 GMT

Thanks Rob