Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Metadata

Not applicable

Metadata

With the release of QlikView 10 comes the addition of Metadata. Metadata has a wide range of uses. In QlikView, it allows to add Tags and Comments to your fields and tables (Comments only). Utilizing this new functionality will allow you to provide your users with additional information in a friendly matter.

Tags

Tags can only be used on fields and allow you to signify attributes related to that field. For example, you could identify a field as a Dimension, a Date or a Key.

To define a Tag in your script, use the following syntax:

TAG [FIELD|FIELDS] field_name WITH tag_name;
TAG FIELD Customer WITH $dimension;
TAG FIELDS Sales, NetSales WITH $measure;

Comments

Comments can be added to tables or fields and allow for a more detailed definition of the object. Utilizing Comments allows to define your table and field names to ease development without forcing your users to memorize what those names represent.

To define a Comment in your script, use the following syntax:

COMMENT [FIELD] field_name WITH comment;
COMMENT table_name WITH comment;
COMMENT FIELD GrossRev WITH 'Gross Revenue; US Dollars';
COMMENT TABLE SalesFin WITH 'Sales with Finance focus.';

Metadata in Your Application

Once you have defined some Metadata in your application, there are a couple of places where it will be used.

The first location will be Document Settings, on the Tables tab. On this tab, you will see a list of the tables loaded in the application along with the fields for a selected table. You will see a Comment column in the Tables section along with a column for Tags and for Comment for Fields. This is a great place to verify how your Metadata is working, but isn't very helpful to a user.

The users will see you Metadata when adding fields as List Boxes and in Charts. When the user sees a list of fields, they may hover over any field to see the Metadata associated with that field.

Making use of Metadata may be something that requires a little training for your users, but utilizing it will allow them to broaden their use of the applications.

Example

Download exampe file here

Labels (2)
Comments
Luminary
Luminary

NMiller - Very useful information. Please can you also upload the sample file? The url is re-directing to old community site which is broken at the moment.

Thanks in advance.

Cheers - DV

denwo2010
Contributor

hi i am unable to downlload this? any other way this can be download as the link  does not work

Not applicable

I'm sorry, I no longer have the example file. The TAG and COMMENT syntax is pretty straightforward though. Try adding some of these to a document and you should be able to see how they work.

Not applicable

I have never been able to get the COMMENT statement to work. Is there a Document settings somewhere to enable this? 

hariprasadqv
Contributor III

Thank you @NMiller‌, it is very much helpfull in stating metadata.

Eg:

Table1:

LOAD * INLINE [

    Id, Country

    1, Ind

    2, USA

    3, UK

    4, UAE

    5, PAK

];

Table2:

LOAD * INLINE [

    Id, Rating

    1, 3.2

    2, 4.1

    3, 4.8

    4, 4.2

    5, 2.3

  

];

COMMENT Table Table1 WITH 'This is table 1 comment';

TAG FIELD Id WITH $Key;

COMMENT Field Id With 'This id fiels is a perfect key';

Table View:

comments and tag.PNG

Version history
Revision #:
1 of 1
Last update:
‎10-01-2010 01:08 PM
Updated by: