Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank you, But while creating new analysis the joining fields displays to end users which is annoying and i dont want this.
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.
end users see only informations you put on the sheets/objects.
I'm I right ?
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
That cant be done, For specific Fields in sheet level don't think so
After dropping fields at the end, Also remove the join in the data model.
maybe you can hide the fields
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
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