Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
zahidrahim_ocp
Contributor

Hide irrelevant fields

Dear Experts,

While scripting we have many fields which only used to join with other tables like "IDs" etc. Now these fields also show on sheets where we create analysis. These fields are very much irrelevant for end users and annoying. Can we somehow hide these fields so that don't display on sheets and only make it limited to develop a data model and joining only.

Regards,

Zahid Rahim

1 Solution

Accepted Solutions

Re: Hide irrelevant fields

You could use the feature of HidePrefix. After them these fields would be treated like the system-fields $Table, $Field and so on and are hidden in all objects unless the show system-fields checkbox is enabled. For this you need to prefix the fieldnames to a certain sign, for example an underscore:

set HidePrefix='_' ;

- Marcus

18 Replies

Re: Hide irrelevant fields

You can use drop command to remove un-necessary field from your data model.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

Re: Hide irrelevant fields

Drop field ‒ QlikView

See above link.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
darrell_tobin
Contributor

Re: Hide irrelevant fields

Hi Zahid,

I don't think you can remove them, I have had the same issue in the past.  The solution I used was to start the ID fields with a Z.  Such as ZCustomerId.  This will put all of the IDs to the end of the drop down lists so not getting in the war of the user, putting them all in the same place but still there.

Thanks

Darrell

Please mark as helpful and correct if applicable.

Re: Hide irrelevant fields

If irrelevant the Don't load them, Load which needed and store into QVD that will optimized ..

Life is so rich, and we need to respect to the life !!!
zahidrahim_ocp
Contributor

Re: Hide irrelevant fields

If i drop fields then will the join effect? Also can you please share the syntax to drop fields.

zahidrahim_ocp
Contributor

Re: Hide irrelevant fields

i need those fields to join other tables but dont need on sheets.

Re: Hide irrelevant fields

Drop those field after join.

or you can drop at end of script.

Syntax search in help menu.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

Re: Hide irrelevant fields

Then, call the fields in script and don't call them into Sheets? or create flag for that and use Flag name to Sheet level. Nothing changes then please post some more information

Life is so rich, and we need to respect to the life !!!
YoussefBelloum
Esteemed Contributor

Re: Hide irrelevant fields

If those fields are joining fields, you can't remove them, but you can easily don't show them on the sheets, simply by not adding them on the Objects

Community Browser