topic Re: Hiding values in current selection box in QlikView

Hiding values in current selection box

marksmunich — Tue, 18 Jun 2013 08:23:21 GMT

How to hide some values in the current selection box from being displayed. Since it is confusing for the end user to understand the selections. I want to hide some selecetions, so the current selections box is easy to understand.

Re: Hiding values in current selection box

Tue, 18 Jun 2013 08:28:35 GMT

The way to do this is to use the HidePrefix value in the load script, this will make sure that certain fields can be selected but will never show up on the current selections box.

In the load script, somewhere at the start, add the line:

SET HidePrefix='%';

Then, whenever you want a field to be selecteable, but not included in the current selections box, you need to alias it like this:

LOAD A, B, C AS %C FROM TableName;

So, field C can be selected, but will not appear in the selections box.

Note: the % symbol is what I use, but you can use anything you like in there.

Regards,

Nigel.

Re: Hiding values in current selection box

Tue, 18 Jun 2013 08:39:58 GMT

see this link, this helps you.

http://qlikshare.com/575

http://community.qlik.com/message/23187#23187

Regards

Re: Hiding values in current selection box

juliacowbe — Fri, 27 Sep 2019 18:10:30 GMT

Does this work for qlik sense too?