Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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