topic Hide field from users in QlikView

Hide field from users

ryanhicks — Thu, 31 Oct 2013 18:40:36 GMT

I have two fields that due to regulatory reasons cannot be used together in a chart/graph. Both fields are needed in the tool so we do not want to remove either of them.

The issue is we want our users to be able to create their own charts, but not using either of these fields. So basically we do not want these fields to show in the list of fields.

We have looked at using the hide prefix to make these system fields, but this makes them not show up in the current selections box.

Is there a way to hide a field from an end user (like a system field), but still allow it to show up in the current selections box?

Thank you for your help.

Ryan

Re: Hide field from users

Clever_Anjos — Thu, 31 Oct 2013 18:57:04 GMT

TAG Field yourfield $hidden;

But will hide from current selections too

Re: Hide field from users

wms_manis — Thu, 31 Oct 2013 20:16:12 GMT

Prefix the field with a character. '%' for example.

Then issue the Set hideprefix = '%'; statement

The field can be used in an expression, but it won't be seen by the users.

Wade

www.serviambi.com

Re: Hide field from users

ryanhicks — Fri, 01 Nov 2013 12:12:29 GMT

We have tried this but this hides the field from the current selecitons box which is not acceptable.

Re: Hide field from users

ryanhicks — Fri, 01 Nov 2013 12:13:34 GMT

The field musty be able to be seen in the current selections box though. Any idea on how to add a hidden field to the current seletions box?