topic Re: Hide fields in QlikView

Hide fields

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I want to Hide some fields so that they will not appear in "Available fields".?

Thanks

Re: Hide fields

oknotsen — Wed, 01 Mar 2017 13:00:09 GMT

Make sure the fieldname has a specific prefix (like HIDE or something obvious).

Next, SET the HIDEPREFIX variable to that specific prefix.

HidePrefix ‒ QlikView

Re: Hide fields

tresB — Wed, 01 Mar 2017 13:00:15 GMT

Check it here: HidePrefix – hiding fields

Re: Hide fields

Anonymous — Wed, 01 Mar 2017 13:34:32 GMT

Thank u all.

But Fields are available when I check "Show system fields". but I want to hide them though "Show system fields" checked.

Thanks and Regards

Re: Hide fields

oknotsen — Wed, 01 Mar 2017 13:41:45 GMT

If they are not needed, drop those fields instead.

If they are needed for the data model, they will stay visible that way.

Re: Hide fields

avinashelite — Wed, 01 Mar 2017 14:13:19 GMT

You cannot hide from the "Show system fields"... and I agree with okg‌ if you don't even need it in the "Show system fields" then what the need of those columns

Re: Hide fields

Anonymous — Wed, 01 Mar 2017 15:20:56 GMT

Actually I need those field just to make association only. so its no use to show them in "Available fields".

Re: Hide fields

oknotsen — Wed, 01 Mar 2017 15:32:44 GMT

And that is exactly why you use HIDEPREFIX .

Re: Hide fields

Anonymous — Wed, 01 Mar 2017 15:58:05 GMT

yes okg‌. but they are visible when "show system fields" checked

Re: Hide fields

oknotsen — Wed, 01 Mar 2017 17:08:43 GMT

They are indeed and there is nothing you can change about that.

Your designer will, under normal circumstances, not need the system field, so just uncheck that.