Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
Please find the attached image.
in that picture in tags i am having $numeric,$text but i want to remove all these type of tags and i need add my commets there.
and also the problem is i am having 600 fields so i cant go and add it for each and every field. so how i can load this fully without doing one by one
thnx
On QlikView Help you can find a specific section for Field Tags:
"There are three different types of system tags, script generated system tags that cannot be altered by the user, script generated system tags that can be altered in the script and system tags that are set interactively by the user. System tags are always preceded by a $ sign.
The following system tags are automatically generated at the end of script generation. These cannot be changed by the user:
$system - denotes a system field.
$key - denotes a key field.
$keypart - denotes that the field is part of one or more synthetic keys.
$synthetic - denotes a synthetic key.
The following tags are also automatically generated at the end of script generation, but may be altered or overridden using script syntax, see Tag Field and Untag Field.
$hidden - denotes a hidden field.
$numeric - all (non-null) values in the field are numeric.
$integer - all (non-null) values in the field are integers.
$text - no values in the field are numeric.
$ascii - field values contain only standard ascii characters.
$date - all (non-null) values in the field can be interpreted as dates (integers).
$timestamp - all (non-null) values in the field can be interpreted as time stamps.
The following tags are set in the Document Properties: Tables dialog. They can be enabled and disabled by the user:
$dimension - denotes a field recommended for use in chart dimensions, list boxes, etc.
$measure - denotes a field recommended for use in expressions.
The user can also add custom tags. These are added either in the script using Script Syntax or in the Document Properties: Tables dialog. These custom tags may not use the same name as any system tag.
Note!
If the same tags are manipulated in both the script and in Document Properties: Tables the settings in the script will prevail.
"
Hi Andrea,
thats fine is there any way to tag the fields as per our wish in script??
thnx
In the QlikView help file you can find all details for generating field tags.
See the "Field tag" section.
"Tag Field
Provides a way of assigning tags to a field. Field names not present in the document are ignored. If conflicting occurrences of a field or tag name are found, the last value is used.
A field tagged with dimension will be displayed at the top of all field selection controls in QlikView except in the Edit Expression dialog.
A field tagged with measure will be displayed at the top of all field selection controls in the Edit Expression dialog.
The keyword can be used to add tags to a field using the syntax:
tag fields fieldlist using mapname
fieldlist is a comma separated list of the fields that should be tagged from this point in the script.
mapname is the name of a mapping table previously read in a Mapping load or Mapping select statement.
To set individual tags, the following syntax is used:
tag field fieldname with tagname
fieldname is the name of the field that should be tagged.
tagname is the name of the tag that should be applied to the field.
Example 1:
tagmap:
mapping Load * inline [
a,b
Alpha,MyTag
Num,MyTag
];
tag fields using tagmap;
Example 2:
tag field Alpha with ‘MyTag2’;
"
Default tags will be there. Also you can add your own tags to which will be displayed there
Using Tag Field FieldName with ‘MyTagName’;
HelpFile:
tag fields fieldlist using mapname
fieldlist is a comma separated list of the fields that should be tagged from this point in the script.
mapname is the name of a mapping table previously read in a Mapping load or Mapping select statement.
To set individual tags, the following syntax is used:
tag field fieldname with tagname
fieldname is the name of the field that should be tagged.
tagname is the name of the tag that should be applied to the field.
Example 1:
tagmap:
mapping Load * inline [
a,b
Alpha,MyTag
Num,MyTag
];
tag fields using tagmap;
Example 2:
tag field Alpha with ‘MyTag2’;