topic Re: prefix in QlikView

prefix

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: prefix

hector_munoz — Tue, 21 Feb 2017 17:11:39 GMT

Hi Balakrishna,

You mean Hideprefix?

Regards,
H

Re: prefix

qlikview979 — Tue, 21 Feb 2017 17:17:03 GMT

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

Re: prefix

Wed, 22 Feb 2017 02:45:41 GMT

Héctor Muñoz Martín,

yes i want hide prefix

Re: prefix

ramasaisaksoft — Wed, 22 Feb 2017 05:07:34 GMT

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.

Re: prefix

rahulpawarb — Wed, 22 Feb 2017 05:19:55 GMT

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

Re: prefix

Anonymous — Wed, 22 Feb 2017 05:48:40 GMT

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

Re: prefix

Wed, 22 Feb 2017 06:47:09 GMT

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

Re: prefix

Wed, 22 Feb 2017 09:01:14 GMT

pls have a look on my previous post