Use of "%" sign as prefix in front of the field names.

[sebbe1975]

Hello,

I'm new to Qlikview and I wonder why we use the "%" sign in front of the field names.

For example:

LOAD *,  Date  as   %ItemPurchased_Date

What is the difference between the above and LOAD *,  Date as  ItemPurchased_Date without the  "%" sign?

Please explain it to me!

[sunny_talwar · Accepted solution]

Check here

HidePrefix 

[sebbe1975]

Hello, Sunny

Sorry, why would I need to hide the filed name that I have created myself?

% = HidePrefix

Could you please give an example?

[sunny_talwar · Accepted solution]

There are times when certain fields are created for selection, but they are not necessarily needed to be displayed to the user via current selection box. They are just used for seamless use of the dashboard. In those cases HidePrefix can come in handy.

I have not read through this, but this might also give other reasons or use cases for HidePrefix

https://community.qlik.com/t5/Qlik-Design-Blog/HidePrefix-hiding-fields/ba-p/1471172 

[sebbe1975]

Thank you

[bharathadde]

% is used to hide fields in current selections and search box