topic Re: How to reset a HidePrefix? in QlikView

How to reset a HidePrefix?

datanibbler — Mon, 02 Oct 2017 11:09:40 GMT

Hi,

in one of my apps there must be a HidePrefix set, I cannot think of anything else: Two fields which are definitely in the LOAD and both of which begin with a "%" are not displayed and I cannot select them on the GUI - but I see that they are there in the table_Viewer. And when I tick the Checkbox "Show System fields", there they are ... but I don't want to hide those fields.

How can I reset that?

Thanks a lot!

Best regards,

DataNibbler

Re: How to reset a HidePrefix?

sunny_talwar — Mon, 02 Oct 2017 11:21:08 GMT

Have not tried this... but reload the application with another hideprefix and may be then the old one will become inactive... I will testing it now...

Re: How to reset a HidePrefix?

sunny_talwar — Mon, 02 Oct 2017 11:24:20 GMT

Yup, just tested it out and it seems to be working...

First to hide

SET HidePrefix = '%';

//SET HidePrefix = '_';

Table:

LOAD * INLINE [

];

next to unhide

//SET HidePrefix = '%';

SET HidePrefix = '_';

Table:

LOAD * INLINE [

];

Re: How to reset a HidePrefix?

datanibbler — Mon, 02 Oct 2017 11:37:05 GMT

Ah, okay - I found a solution. Apparently, there can be only one HidePrefix - so I just set it to something else, now it's okay. I have removed it altogether again since variables do not Change all by themselves.

Seems we had the same idea Sunny. Thanks a lot anyway!

Best regards,

DataNibbler