prefix

[#1]

hi all,

what is prefix id? what is the use of prefix id? when will go for prefix id? give me one suitable example for prefix id?

[hector_munoz]

Hi Balakrishna,

You mean Hideprefix?

Regards,
H

[qlikview979]

Hi

Do u mead

Set hideprefix='@';

T1:

load * inline [

Id,Name,@Sales

1,A,100

2,B,200

];

current selection box  will  hide the '@Sales' field.

Regards,

mahesh

[#4]

hi

Héctor Muñoz Martín,

yes i want hide prefix

[ramasaisaksoft]

There are a number of functions and features in QlikView which whilst they are not revolutionary can make your life much easier.  One such little known feature is HidePrefix.

Often when loading data from complex data sources there are fields in the data model that are required to be pulled in that you do not want to be visible to your analyser users.  It may even simply be that there are so many of them that you don’t wan them in your own way all the time either.  Typically these fields may be join keys or fields that are only used in Set Analysis.

If this sounds familiar you will be pleased to know that these fields can be hidden from view and treated in the same way as the system fields.  As you probably know system fields can be shown or hidden using the check box on the Select Fields dialog.

With HidePrefix you can make your own fields visible or not based on the same check box.

Simply decide which character you wish to use to prefix fields you wish to hide (I always go for the % symbol) and issue the HidePrefix statement:

Once this has been done you simply need to name all fields that you wish to hide so that they start with that character.  Typically you will want to do this with an AS statement (as shown below) – but you can do it at source if you wish:

Once the script has been re-run and the data has been loaded you will notice that the fields that were prefixed only appear in the field selection box when Show System Fields is ticked.

Similar to the actual system fields; the hidden fields can be used at will in expressions, they just can not be selected from the pick lists when defining dimensions or from the drop down when building an expression.

No more will join keys or system ID’s clutter your nice pick list of available fields.

[rahulpawarb]

Hello Balkrishna,

HidePrefix is used for Hiding fields. Key fields can cause confusion in the QlikView front-end. As these fields are used in multiple tables, they can return unexpected results when used in an aggregation function. It is therefore advisable to hide these fields from the front-end view. There are two variables that can be used to hide fields: HidePrefix and HideSuffix.

The first variable hides all field names that start with a specific text string and the second one hides all field names that end with a specific text string. To hide key fields starting with % sign, we can add the following statement at the start of our script: SET HidePrefix='%';

Hope this will help.

Reference: QlikView 11 for Developers.pdf

Regards!

Rahul

[Anonymous]

Hi Balakrishna,

HIdeperfix is used to hide particular field front end side,field will be consider as system field,by using show system field option you can view the field.

Regards,

Murali Mohan .T

[#8]

Hi Bala,

we have hideprefix  in qlikview ,which is used to hide the field selections in current selection box

set hideprefix='_';

load   *,  id as _id  ;

load

id,

name

from  ...xl1;

if u add both columns(id and _id) into front end make selections , id selection will show up In current selection box

_id will not show up in current selection box

[#9]

pls have a look on my previous post