Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I recently was trying to understand system fields and that is when i came across Hideprefix/Hidesuffix statements.
When i set a symbol (%) with hideprefix i.e. SET hideprefix ='%' and use it for naming a field as %test, then %test is not displayed in current selection.
This is exactly as per the explanation in one of Qlik Discussion example on system fields
In order to understand whether hideprefix is a function or just another user-defined variable, i replaced it with user i.e. SET user='%'.
But still i cannot see %test in current selection. I have deleted hideprefix from Variable overview and also checked Show System Fields, but no luck.
Request someone to please answer how can i make filed %test visible again.
Also what is the significance of using hideprefix when associated values of the hidden field value can be seen?
Kind Regards,
Nupur
HIDEPREFIX and HIDESUFFIX are variables. The nature of variables is such that they stay set even if you don't actually initialize them anymore the next time you run your load script. But you can unset them by using the following ... SET
SET HIDEPREFIX=;
Rename %test to test might do the trick.
Hide prefix is a way to hide your keys from selections. Or other fields that should not be selected for any reason.
HIDEPREFIX and HIDESUFFIX are variables. The nature of variables is such that they stay set even if you don't actually initialize them anymore the next time you run your load script. But you can unset them by using the following ... SET
SET HIDEPREFIX=;
Better way is to rename the field and try.
a bit of explanation on this thread
Hi Michiel,
Thank you for your quick response.
Thank you all for quick responses.
Got much clear understanding now.
Kind regards,
Nupur