Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Can I hide table fields?

Is there a way to hide table column fields?

For example, I have a product's currency conversion rate, I don't want to show that to end users.

I just need to use it in a calculation and I'll show the resulting measure to the end users.  (Can't have them seeing a rate then trying to aggregate on it or getting confused, etc...)

Is there a way to hide that field from view but still make it available for myself when building measures?

Thanks!

6 Replies

Re: Can I hide table fields?

phaneendra_kunc
Valued Contributor III

Re: Can I hide table fields?

add a prefix to your fields, in other words rename them something like below and add a hide prefix in script.

SET hideprefix ='%';

Rename FIELD to [%FIELD];

or you could alias on the load statement.

Not applicable

Re: Can I hide table fields?

Can I hide and un-hide as wanted?

That is to say, I go to do some development work and need to un-hide a filed, if I re-hide it later will that break any measures that reference it due to the name of the field itself changing?

Re: Can I hide table fields?

It does have a potential of breaking your expressions. So I would not hide/re-hide things. May be leave them unhidden during the development phase and then hide them once you are ready to publish them?

Not applicable

Re: Can I hide table fields?

Now how do I handle that?

I finish building, I make 10 measures that reference some hidden fields that are not yet hidden.

Now I go to my fields, make then hidden and reload... do my 10 measures break?

Do they ask me to remap or do I have to edit all 10 by hand to add the hidden prefix to the field reference?

Just not sure how Qlik Sense responds and how to best resolve the issue.

Thanks!

shaimamahmoud
Contributor

Re: Can I hide table fields?

What do you mean by hide and unhide,

If your are developing a visualistion , so what you visualize will be unhidden and visual to end user

It will not be visual until you view it your self ?