topic COMMENT TABLES command in QlikView

COMMENT TABLES command

datanibbler — Wed, 11 Feb 2015 15:24:50 GMT

Hi,

can it be that with linked tables, the COMMENT TABLES command works only on one of them?

I have just tried it out on a data_model where I have

- 2 linked tables

- 2 more tables which are not linked.

The latter 2, I can have comments on no problem. With the 1st table, it also worked - but not with the 2nd (which is linked to the 1st).

Is there some way around this? Otherwise that would, I'm afraid, render that command all but useless as in most apps, the tables are all linked in some way or other.

Best regards,

DataNibbler

Re: COMMENT TABLES command

giakoum — Wed, 11 Feb 2015 15:28:54 GMT

only unless this is a bug.

did you try both version of comment table?

comment tables tablelist using mapname

where

tablelist := (table{,table})
mapname is the name of a mapping table previously read in a mapping load or mapping select statement (see Mapping).

To set individual comments, the following syntax is used:

comment tables tablename with comment

where

tablename is the name of the table that should be commented.
comment is the comment that should be added to the table.

Re: COMMENT TABLES command

datanibbler — Wed, 11 Feb 2015 15:57:45 GMT

Hi ioannis,

I tried the variation with that tablelist and mapping_list just now.

Here, too, my help_file was a bit irritating - it led me to think at first that I had to specify the table_name in the command, but then it would not recognize the word "using". When I deleted the table_name as it was already in that mapping_table, it worked fine - but still the comment does not show up.

Can anyone tell if that works on linked tables (not only on the primary table) in the more up-to-date versions?

My client is quite old, it's 11.0.11440.0 SR2 64-BIT.

Best regards,

DataNibbler

Re: COMMENT TABLES command

giakoum — Wed, 11 Feb 2015 16:15:46 GMT

it does work with SR1

see attached

Re: COMMENT TABLES command

datanibbler — Thu, 12 Feb 2015 07:51:28 GMT

OK.

Thanks!

I'm going to have the most up-to-date version of the Client Software installed on my laptop. So I can already think about how best to standardize the use of this function - there should be rules of what to add as comment to any table in QlikView to best serve the documentation purposes.

Best regards,

DataNibbler