Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

How to reset a HidePrefix?

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

1 Solution

Accepted Solutions
sunny_talwar

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

First to hide

SET HidePrefix = '%';

//SET HidePrefix = '_';

Table:

LOAD * INLINE [

    %1

    1

    2

];

next to unhide

//SET HidePrefix = '%';

SET HidePrefix = '_';

Table:

LOAD * INLINE [

    %1

    1

    2

];

View solution in original post

3 Replies
sunny_talwar

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...

sunny_talwar

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

First to hide

SET HidePrefix = '%';

//SET HidePrefix = '_';

Table:

LOAD * INLINE [

    %1

    1

    2

];

next to unhide

//SET HidePrefix = '%';

SET HidePrefix = '_';

Table:

LOAD * INLINE [

    %1

    1

    2

];

datanibbler
Champion
Champion
Author

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