topic Re: Hide irrelevant fields in QlikView

Hide irrelevant fields

zahidrahim_ocp — Mon, 15 Jan 2018 12:51:24 GMT

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

Re: Hide irrelevant fields

PrashantSangle — Mon, 15 Jan 2018 12:54:09 GMT

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

Regards

Re: Hide irrelevant fields

PrashantSangle — Mon, 15 Jan 2018 12:55:26 GMT

Drop field ‒ QlikView‌

See above link.

Regards

Re: Hide irrelevant fields

darrell_tobin — Mon, 15 Jan 2018 12:57:16 GMT

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

Anil_Babu_Samineni — Mon, 15 Jan 2018 12:58:16 GMT

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

Re: Hide irrelevant fields

zahidrahim_ocp — Mon, 15 Jan 2018 12:59:16 GMT

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

Re: Hide irrelevant fields

zahidrahim_ocp — Mon, 15 Jan 2018 13:00:38 GMT

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

Re: Hide irrelevant fields

PrashantSangle — Mon, 15 Jan 2018 13:01:15 GMT

Drop those field after join.

or you can drop at end of script.

Syntax search in help menu.

Regards

Re: Hide irrelevant fields

Anil_Babu_Samineni — Mon, 15 Jan 2018 13:02:19 GMT

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

Re: Hide irrelevant fields

YoussefBelloum — Mon, 15 Jan 2018 13:04:02 GMT

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

Re: Hide irrelevant fields

zahidrahim_ocp — Mon, 15 Jan 2018 13:08:54 GMT

Thank you, But while creating new analysis the joining fields displays to end users which is annoying and i dont want this.

Re: Hide irrelevant fields

zahidrahim_ocp — Mon, 15 Jan 2018 13:10:33 GMT

What information you need?

I just want to make few fields hide to end user in sheets where user find his dimensions and measure. But those fields are very much required in script to join my data model.

Re: Hide irrelevant fields

YoussefBelloum — Mon, 15 Jan 2018 13:13:53 GMT

end users see only informations you put on the sheets/objects.

I'm I right ?

Re: Hide irrelevant fields

marcus_sommer — Mon, 15 Jan 2018 13:15:21 GMT

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

Re: Hide irrelevant fields

Anil_Babu_Samineni — Mon, 15 Jan 2018 13:16:48 GMT

That cant be done, For specific Fields in sheet level don't think so

Re: Hide irrelevant fields

zahidrahim_ocp — Mon, 15 Jan 2018 13:16:52 GMT

After dropping fields at the end, Also remove the join in the data model.

Re: Hide irrelevant fields

maxgro — Mon, 15 Jan 2018 13:17:12 GMT

maybe you can hide the fields

HidePrefix – hiding fields

Re: Hide irrelevant fields

zahidrahim_ocp — Mon, 15 Jan 2018 13:24:19 GMT

Dear Marcus,

Thank you very much for the answer.

In Qlik Sense Enterprise Studio where can i find the option show system fields?

Regards,

Zahid Rahim

Re: Hide irrelevant fields

marcus_sommer — Mon, 15 Jan 2018 14:13:57 GMT

This enabling/disabling is possible within QlikView by Qlik Sense I don't know but I assume that there is not such feature implemented yet. But you could display them with measure like this:

Using system fields in a visualization ‒ Qlik Sense

- Marcus