Reveal "HidePrefix" fields

[#1]

After use "SET HidePrefix" must use fields in the interface but I can not find them (of course I can just write their name, but with a large amount of hidden fields it is very uncomfortable).

Is there a magic button, which displays all the hidden fields?

[Miguel_Angel_Baeyens]

Hi,

There is not. But if you need to have all of them visible, then you could use a loop and remove the hidden prefix character in every field name, with RENAME USING.

Miguel

[#3]

Thanks, but users will be discouraged by seeing a huge amount of obscure fields.

Untill this function added, ill comment HidePrefix for development and uncomment it when send user releese.

[Colin-Albert]

Can you reset hideprefix to something else and reload the data?

[Miguel_Angel_Baeyens]

Sorry, I was about to say that when I realized I always look for the most complex way of doing things!

Either commenting it, or changing the character to any other, or if you do need them, add them from the Data Model Viewer > Preview > Add Dimension so it will appear on the Master Items library under Dimensions even with the hidden prefix and therefore you can drag and drop to any new object.

Miguel

[simenkg]

let Hideprefix = null();

Reload the script.
Add the fields to the model.

Change back to Set Hideprefix = ...;

Reload.

[Anonymous]

Try checking the Show System Fields option in the Gneral tab of User Preferences.

[Miguel_Angel_Baeyens]

Greeshma,

No User Preferences in Qlik Sense Desktop

Miguel